APPS.INV_RCV_DIAG_LCM_05 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_TRANSACTIONS_INTERFACE[Top]');

Line: 40

   sqltxt :=     ' SELECT rti.* '                                                ||
		 ' FROM   rcv_transactions_interface rti,'                       ||
		 '        rcv_parameters             rp,'                        ||
		 '        po_line_locations_all      pll'                        ||
    	         ' WHERE  rti.po_line_location_id is not null '                  ||
		 ' AND    rti.po_line_location_id = pll.line_location_id  '      ||
                 ' AND    pll.lcm_flag = ''Y''  '                                ||
		 ' AND    rti.to_organization_id = rp.organization_id'           ||
		 ' AND    rp.pre_receive <> ''Y''  '                             ||
		 ' AND    rti.transaction_type in (''RECEIVE'', ''SHIP'')'       ||
		 ' AND    rti.auto_transact_code in (''RECEIVE'', ''DELIVER'')'  ||
		 ' AND    rti.processing_mode_code in (''IMMEDIATE'', ''ONLINE'')' ;

Line: 56

   JTF_DIAGNOSTIC_COREAPI.insert_html('');

Line: 57

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

Line: 58

   sqltxt :=     ' SELECT pll.* '                                                ||
		 ' FROM   rcv_transactions_interface rti,'                       ||
		 '        rcv_parameters             rp,'                        ||
		 '        po_line_locations_all      pll'                        ||
    	         ' WHERE  rti.po_line_location_id is not null '                  ||
		 ' AND    rti.po_line_location_id = pll.line_location_id  '      ||
                 ' AND    pll.lcm_flag = ''Y''  '                                ||
		 ' AND    rti.to_organization_id = rp.organization_id'           ||
		 ' AND    rp.pre_receive <> ''Y''  '                             ||
		 ' AND    rti.transaction_type in (''RECEIVE'', ''SHIP'')'       ||
		 ' AND    rti.auto_transact_code in (''RECEIVE'', ''DELIVER'')'  ||
		 ' AND    rti.processing_mode_code in (''IMMEDIATE'', ''ONLINE'')' ;

Line: 74

   JTF_DIAGNOSTIC_COREAPI.insert_html('');

Line: 75

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

Line: 76

   sqltxt :=     ' SELECT rp.* '                                                 ||
		 ' FROM   rcv_transactions_interface rti,'                       ||
		 '        rcv_parameters             rp,'                        ||
		 '        po_line_locations_all      pll'                        ||
    	         ' WHERE  rti.po_line_location_id is not null '                  ||
		 ' AND    rti.po_line_location_id = pll.line_location_id  '      ||
                 ' AND    pll.lcm_flag = ''Y''  '                                ||
		 ' AND    rti.to_organization_id = rp.organization_id'           ||
		 ' AND    rp.pre_receive <> ''Y''  '                             ||
		 ' AND    rti.transaction_type in (''RECEIVE'', ''SHIP'')'       ||
		 ' AND    rti.auto_transact_code in (''RECEIVE'', ''DELIVER'')'  ||
		 ' AND    rti.processing_mode_code in (''IMMEDIATE'', ''ONLINE'')' ;