APPS.INV_RCV_DIAG_LCM_03 SQL Statements

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

Line: 37

   JTF_DIAGNOSTIC_COREAPI.insert_style_sheet;

Line: 40

   JTF_DIAGNOSTIC_COREAPI.insert_html('');

Line: 41

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

Line: 42

   sqltxt :=     ' SELECT rsh.*'                                                   ||
                 ' FROM   rcv_shipment_headers rsh'                                ||
                 ' WHERE  rsh.shipment_header_id in '                              ||
                 '       ( SELECT distinct rt.shipment_header_id '                 ||
		 '         FROM   rcv_transactions      rt,'                       ||
		 '                po_line_locations_all pll'                       ||
    	         '         WHERE  rt.po_line_location_id is not null '             ||
		 '         AND    rt.po_line_location_id = pll.line_location_id'   ||
                 '         AND    pll.lcm_flag =  ''Y''  '                         ||
		 '         AND    unit_landed_cost is null)';

Line: 56

   JTF_DIAGNOSTIC_COREAPI.insert_html('');

Line: 57

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

Line: 58

   sqltxt :=     ' SELECT rsl.*'                                                   ||
                 ' FROM   rcv_shipment_lines rsl'                                  ||
                 ' WHERE  rsl.shipment_line_id in '                                ||
                 '       ( SELECT distinct rt.shipment_line_id '                   ||
		 '         FROM   rcv_transactions      rt,'                       ||
		 '                po_line_locations_all pll'                       ||
    	         '         WHERE  rt.po_line_location_id is not null '             ||
		 '         AND    rt.po_line_location_id = pll.line_location_id'   ||
                 '         AND    pll.lcm_flag =  ''Y''  '                         ||
		 '         AND    unit_landed_cost is null)';

Line: 72

   JTF_DIAGNOSTIC_COREAPI.insert_html('');

Line: 73

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

Line: 74

   sqltxt :=     ' SELECT rt.* '                                           ||
		 ' FROM   rcv_transactions      rt,'                       ||
		 '        po_line_locations_all pll'                       ||
    	         ' WHERE  rt.po_line_location_id is not null '             ||
		 ' AND    rt.po_line_location_id = pll.line_location_id'   ||
                 ' AND    pll.lcm_flag =  ''Y''  '                         ||
		 ' AND    unit_landed_cost is null'                        ||
		 ' ORDER BY rt.shipment_header_id, rt.shipment_header_id, rt.transaction_id' ;

Line: 87

   JTF_DIAGNOSTIC_COREAPI.insert_html('');

Line: 88

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

Line: 89

   sqltxt :=     ' SELECT pll.* '                                           ||
		 ' FROM   rcv_transactions      rt,'                       ||
		 '        po_line_locations_all pll'                       ||
    	         ' WHERE  rt.po_line_location_id is not null '             ||
		 ' AND    rt.po_line_location_id = pll.line_location_id'   ||
                 ' AND    pll.lcm_flag =  ''Y''  '                         ||
		 ' AND    unit_landed_cost is null'                        ||
		 ' ORDER BY rt.shipment_header_id, rt.shipment_header_id, rt.transaction_id' ;

Line: 102

   JTF_DIAGNOSTIC_COREAPI.insert_html('');

Line: 103

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

Line: 104

   sqltxt :=     ' SELECT  mp.* '                                                 ||
                 ' FROM    mtl_parameters mp'                                     ||
                 ' WHERE   mp.organization_id in'                                 ||
                 '        ( SELECT distinct rt.organization_id'                   ||
		 '          FROM   rcv_transactions      rt,'                     ||
		 '                 po_line_locations_all pll'                     ||
    	         '          WHERE  rt.po_line_location_id is not null '           ||
		 '          AND    rt.po_line_location_id = pll.line_location_id' ||
		 '          AND    pll.lcm_flag =  ''Y''  '                       ||
		 '          AND    rt.unit_landed_cost is null)';

Line: 119

   JTF_DIAGNOSTIC_COREAPI.insert_html('');

Line: 120

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

Line: 121

   sqltxt :=     ' SELECT  rp.* '                                                 ||
                 ' FROM    rcv_parameters rp'                                     ||
                 ' WHERE   rp.organization_id in'                                 ||
                 '        ( SELECT distinct rt.organization_id'                   ||
		 '          FROM   rcv_transactions      rt,'                     ||
		 '                 po_line_locations_all pll'                     ||
    	         '          WHERE  rt.po_line_location_id is not null '           ||
		 '          AND    rt.po_line_location_id = pll.line_location_id' ||
		 '          AND    pll.lcm_flag =  ''Y''  '                       ||
		 '          AND    rt.unit_landed_cost is null)';