APPS.JA_JAIN57PI_XMLP_PKG SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 25

  SELECT 	MIN( CREATION_DATE) INTO CP_FROM_DATE
  FROM  	JAI_PO_OSP_HDRS F3
  WHERE 	F3.ORGANIZATION_ID 	= P_ORGANIZATION_ID
  AND		F3.LOCATION_ID 		= NVL(P_LOCATION_ID,F3.LOCATION_ID);

Line: 45

    APPL_SHORT_NAME="INV" OUTPUT=":P_ITEM_FLEXDATA" MODE="SELECT" TABLEALIAS="MSI"');

Line: 47

   WHEN SRW.USER_EXIT_FAILURE THEN SRW.MESSAGE(020,'FAILED IN BEFORE REPORT TRIGGER, ITEM SELECT. ');