Sunday, April 24, 2016

Printed Requisitions Report ,GET FLEXFIELD DATA INTO REPORT

TICKET 4: Printed Requisitions Report
WHAT IS:The Printed Requisitions Report prints the requisitions which have the following status: Approved, Rejected, In Process, Pre-Approved, and Returned. The report does not include requisitions with status Incomplete or cancelled. 
What It Is:
It displays requisition details consists item details, qnty, price, preparer name, account details
Etc
Customization:
GET FLEXFIELD DATA INTO REPORT &TO PRINT ACCOUNT DESCRIPTION
Parameters:
From Requisition No, To requisition No
Tables:
Po_reuision_headers_all, po_requisition_lines_all, po_req_distributions_all,gl_code_combinations, po_line_types,per_all_people_f, mtl_system_items_b, mtl_item_categories,po_document_types……




In C_FLEX_DESC  Added Formula Column Query is
function C_FLEX_DESCFormula return Char is
begin
  BEGIN
  SRW.REFERENCE(:C_FLEX_ACC);
  SRW.USER_EXIT('FND FLEXIDVAL CODE           ="GL#"
                               APPL_SHORT_NAME="SQLGL"
                               DATA           =":C_FLEX_ACC"
                               DESCRIPTION     =":C_FLEX_DESC"
                               DISPLAY        ="ALL" 
                               NUM  =         =":STRUCTURE_ACC1"');
  RETURN(:C_FLEX_DESC);
EXCEPTION
  WHEN SRW.USER_EXIT_FAILURE THEN
    RETURN('User Exit Failure');
END;

RETURN NULL;
end;





No comments:

Post a Comment

Types of animations

Animation is a diverse and creative field with a variety of styles that artists and filmmakers use to bring their visions to life. Here are ...