APPS.INV_RCV_DIAG_LCM_04 SQL Statements

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

Line: 35

   JTF_DIAGNOSTIC_COREAPI.insert_style_sheet;

Line: 38

   JTF_DIAGNOSTIC_COREAPI.insert_html('');

Line: 39

   JTF_DIAGNOSTIC_COREAPI.insert_html('RCV_SHIPMENT_HEADERS[Top]');

Line: 40

   sqltxt :=     ' SELECT rsh.* '                                    ||
		 ' FROM   rcv_shipment_headers rsh,'                 ||
		 '        rcv_parameters       rp'                   ||
    	         ' WHERE  rsh.ship_to_org_id = rp.organization_id '  ||
		 ' AND    rp.pre_receive = ''Y''  '                  ||
                 ' AND    rsh.asn_type = ''ASN''  '                  ||
		 ' AND    rsh.creation_date >= rp.last_update_date' ;

Line: 52

   JTF_DIAGNOSTIC_COREAPI.insert_html('');

Line: 53

   JTF_DIAGNOSTIC_COREAPI.insert_html('RCV_PARAMETERS[Top]');

Line: 54

   sqltxt :=     ' SELECT distinct rp.* '                            ||
		 ' FROM   rcv_shipment_headers rsh,'                 ||
		 '        rcv_parameters       rp'                   ||
    	         ' WHERE  rsh.ship_to_org_id = rp.organization_id '  ||
		 ' AND    rp.pre_receive = ''Y''  '                  ||
                 ' AND    rsh.asn_type = ''ASN''  '                  ||
		 ' AND    rsh.creation_date >= rp.last_update_date' ;