APPS.INV_RCV_DIAG_LCM_02 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: 41

   sqltxt :=     ' select rsh.* ' ||
                 ' FROM   rcv_shipment_lines   rsl,'                                     ||
                 '        rcv_shipment_headers rsh '                                     ||
    	         ' WHERE  rsh.shipment_header_id = rsl.shipment_header_id'               ||
    	         ' AND    lcm_shipment_line_id in '                                      ||
		 '       ( SELECT lcm_shipment_line_id'                                  ||
                 '         FROM  (SELECT lcm_shipment_line_id,  count(shipment_line_id)' ||
		 '                FROM   rcv_shipment_lines'                             ||
		 '                WHERE  lcm_shipment_line_id is not null'               ||
		 '                GROUP BY lcm_shipment_line_id'                         ||
		 '                HAVING COUNT(shipment_line_id) > 1))'                  ||
		 ' ORDER BY lcm_shipment_line_id, shipment_line_id';

Line: 58

   JTF_DIAGNOSTIC_COREAPI.insert_html('');

Line: 59

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

Line: 61

   sqltxt :=     ' select * ' ||
                 ' FROM   rcv_shipment_lines'                                            ||
                 ' WHERE  lcm_shipment_line_id in '                                      ||
                 '       ( SELECT lcm_shipment_line_id'                                  ||
                 '         FROM  (SELECT lcm_shipment_line_id,  count(shipment_line_id)' ||
		 '                FROM   rcv_shipment_lines'                             ||
		 '                WHERE  lcm_shipment_line_id is not null'               ||
		 '                GROUP BY lcm_shipment_line_id'                         ||
		 '                HAVING COUNT(shipment_line_id) > 1))'                  ||
		 ' ORDER BY lcm_shipment_line_id, shipment_line_id';

Line: 75

   JTF_DIAGNOSTIC_COREAPI.insert_html('');

Line: 76

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

Line: 78

   sqltxt :=     ' select pll.* ' ||
                 ' FROM   rcv_shipment_lines    rsl,'                                    ||
                 '        po_line_locations_all pll '                                    ||
    	         ' WHERE  pll.line_location_id = rsl.po_line_location_id'                ||
    	         ' AND    lcm_shipment_line_id in '                                      ||
		 '       ( SELECT lcm_shipment_line_id'                                  ||
                 '         FROM  (SELECT lcm_shipment_line_id,  count(shipment_line_id)' ||
		 '                FROM   rcv_shipment_lines'                             ||
		 '                WHERE  lcm_shipment_line_id is not null'               ||
		 '                GROUP BY lcm_shipment_line_id'                         ||
		 '                HAVING COUNT(shipment_line_id) > 1))'                  ||
		 ' ORDER BY lcm_shipment_line_id, shipment_line_id';

Line: 95

   JTF_DIAGNOSTIC_COREAPI.insert_html('');

Line: 96

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

Line: 98

   sqltxt :=     ' select  mp.* '                                                                 ||
                 ' FROM    mtl_parameters     mp '                                                ||
                 ' WHERE   mp.organization_id in '                                                ||
                 '         (SELECT distinct rsl.to_organization_id '                              ||
                 '          FROM   rcv_shipment_lines rsl,'                                       ||
                 '                 mtl_parameters     mp '                                        ||
                 '          WHERE  rsl.to_organization_id = mp.organization_id'                   ||
                 '          AND    lcm_shipment_line_id in '                                      ||
		 '                ( SELECT lcm_shipment_line_id'                                  ||
                 '                  FROM  (SELECT lcm_shipment_line_id,  count(shipment_line_id)' ||
		 '                         FROM   rcv_shipment_lines'                             ||
		 '                         WHERE  lcm_shipment_line_id is not null'               ||
		 '                         GROUP BY lcm_shipment_line_id'                         ||
		 '                         HAVING COUNT(shipment_line_id) > 1)))';

Line: 117

   JTF_DIAGNOSTIC_COREAPI.insert_html('');

Line: 118

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

Line: 120

   sqltxt :=     ' select  rp.* ' ||
                 ' FROM    rcv_parameters     rp '                                                ||
                 ' WHERE   rp.organization_id in '                                                ||
                 '         (SELECT distinct rsl.to_organization_id '                              ||
                 '          FROM   rcv_shipment_lines rsl,'                                       ||
                 '                 mtl_parameters     mp '                                        ||
                 '          WHERE  rsl.to_organization_id = mp.organization_id'                   ||
                 '          AND    lcm_shipment_line_id in '                                      ||
		 '                ( SELECT lcm_shipment_line_id'                                  ||
                 '                  FROM  (SELECT lcm_shipment_line_id,  count(shipment_line_id)' ||
		 '                         FROM   rcv_shipment_lines'                             ||
		 '                         WHERE  lcm_shipment_line_id is not null'               ||
		 '                         GROUP BY lcm_shipment_line_id'                         ||
		 '                         HAVING COUNT(shipment_line_id) > 1)))';