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;