eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.INV_DIAG_RCV_IOT SQL Statements

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

Line: 106


 JTF_DIAGNOSTIC_COREAPI.insert_style_sheet;

Line: 193


     select Count(*)
     into l_count
     from rcv_shipment_headers rsh,
          rcv_shipment_lines rsl
     where rsh.receipt_num = l_receipt_num
     AND rsh.shipment_num = l_shipment_num
     AND rsh.shipment_header_id = rsl.shipment_header_id
     AND rsl.line_num = l_shipment_line_num
     and rsh.ship_to_org_id = l_org_id
     and rsh.receipt_source_code = 'INVENTORY';

Line: 209


     select Count(*)
     into l_count
     from rcv_shipment_headers rsh,
          rcv_shipment_lines rsl
     where rsh.shipment_num = l_shipment_num
     AND rsh.shipment_header_id = rsl.shipment_header_id
     AND rsl.line_num = l_shipment_line_num
     and rsh.ship_to_org_id = l_org_id
     and rsh.receipt_source_code = 'INVENTORY';

Line: 223


     select Count(*)
     into l_count
     from rcv_shipment_headers rsh,
          rcv_shipment_lines rsl
     where rsh.receipt_num = l_receipt_num
     AND rsh.shipment_header_id = rsl.shipment_header_id
     AND rsl.line_num = l_shipment_line_num
     and rsh.ship_to_org_id = l_org_id
     and rsh.receipt_source_code = 'INVENTORY';

Line: 237


     select Count(*)
     into l_count
     from rcv_shipment_headers rsh
     where rsh.receipt_num = l_receipt_num
     AND rsh.shipment_num = l_shipment_num
     and rsh.ship_to_org_id = l_org_id
     and rsh.receipt_source_code = 'INVENTORY';

Line: 249


     select Count(*)
     into l_count
     from rcv_shipment_headers rsh
     where rsh.shipment_num = l_shipment_num
     and rsh.ship_to_org_id = l_org_id
     and rsh.receipt_source_code = 'INVENTORY';

Line: 260


     select Count(*)
     into l_count
     from rcv_shipment_headers rsh
     where rsh.receipt_num = l_receipt_num
     and rsh.ship_to_org_id = l_org_id
     and rsh.receipt_source_code = 'INVENTORY';

Line: 286


     select shipment_num
     into l_shipment_num
     from rcv_shipment_headers rsh
     where receipt_num = l_receipt_num
     and ship_to_org_id = l_org_id
     and rsh.receipt_source_code = 'INVENTORY';

Line: 303


     select receipt_num
     into l_receipt_num
     from rcv_shipment_headers rsh
     where shipment_num = l_shipment_num
     and ship_to_org_id = l_org_id
     and rsh.receipt_source_code = 'INVENTORY';

Line: 328


JTF_DIAGNOSTIC_COREAPI.insert_style_sheet;

Line: 329


JTF_DIAGNOSTIC_COREAPI.insert_html(''||'
'||'
'||'
'||'
'||'
'||'
'||'
'||'
'||'
'||'
'||'
'||'
'||'
'||'
'||'
'||'
'||'
'||'
'||'
'||'
'||'
'||'
'||'
'||'
'||'
'||'
'||'
'||'
'||'
'||'
'||'
'||'
'||'
'||'
'||'
'||'
'||'
'||'
'||'
'||'

'||'
'||'
'||'
'||'
'||'
'||'
'||'
'||'
'||'
'||'
'||'
'||'
'||'
'||'
'||'
'||'
'||'
INDEX OF QUERIES
RCV_HEADERS_INTERFACE RCV_TRANSACTIONS_INTERFACE PO_INTERFACE_ERRORS
RCV_SHIPMENT_HEADERS RCV_SHIPMENT_LINES RCV_TRANSACTIONS
MTL_SUPPLY RCV_SUPPLY MTL_MATERIAL_TRANSACTIONS_TEMP
MTL_MATERIAL_TRANSACTIONS MTL_LOT_NUMBERS MTL_TRANSACTION_LOT_NUMBERS
MTL_TRANSACTION_LOTS_INTERFACE MTL_TRANSACTION_LOTS_TEMP RCV_LOTS_SUPPLY
RCV_LOT_TRANSACTIONS RCV_LOTS_INTERFACE RCV_SERIALS_SUPPLY
RCV_SERIAL_TRANSACTIONS RCV_SERIALS_INTERFACE MTL_SERIAL_NUMBERS
MTL_SERIAL_NUMBERS_TEMP MTL_SERIAL_NUMBERS_INTERFACE MTL_UNIT_TRANSACTIONS
MTL_SYSTEM_ITEMS MTL_TRANSACTION_TYPES ORG_ORG_DEFINIATIONS
MTL_INTERORG_PARAMETERS MTL_PARAMETERS RCV_PARAMETERS
LOOKUP CODES');

INDEX OF QUERIES
RCV_HEADERS_INTERFACE	RCV_TRANSACTIONS_INTERFACE	PO_INTERFACE_ERRORS
RCV_SHIPMENT_HEADERS	RCV_SHIPMENT_LINES	RCV_TRANSACTIONS
MTL_SUPPLY	RCV_SUPPLY	MTL_MATERIAL_TRANSACTIONS_TEMP
MTL_MATERIAL_TRANSACTIONS	MTL_LOT_NUMBERS	MTL_TRANSACTION_LOT_NUMBERS
MTL_TRANSACTION_LOTS_INTERFACE	MTL_TRANSACTION_LOTS_TEMP	RCV_LOTS_SUPPLY
RCV_LOT_TRANSACTIONS	RCV_LOTS_INTERFACE	RCV_SERIALS_SUPPLY
RCV_SERIAL_TRANSACTIONS	RCV_SERIALS_INTERFACE	MTL_SERIAL_NUMBERS
MTL_SERIAL_NUMBERS_TEMP	MTL_SERIAL_NUMBERS_INTERFACE	MTL_UNIT_TRANSACTIONS
MTL_SYSTEM_ITEMS	MTL_TRANSACTION_TYPES	ORG_ORG_DEFINIATIONS
MTL_INTERORG_PARAMETERS	MTL_PARAMETERS	RCV_PARAMETERS
LOOKUP CODES

Line: 389


JTF_DIAGNOSTIC_COREAPI.insert_html('Receipt Information');

Line: 391


JTF_DIAGNOSTIC_COREAPI.insert_html('');

Line: 392


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

Line: 397


JTF_DIAGNOSTIC_COREAPI.insert_html('');

Line: 398


JTF_DIAGNOSTIC_COREAPI.insert_html('RCV_TRANSACTIONS_INTERFACE  
JTF_DIAGNOSTIC_COREAPI.insert_html('');

Line: 405


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

Line: 411


JTF_DIAGNOSTIC_COREAPI.insert_html('');

Line: 412


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

Line: 418


JTF_DIAGNOSTIC_COREAPI.insert_html('');

Line: 419


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

Line: 425


JTF_DIAGNOSTIC_COREAPI.insert_html('');

Line: 426


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

Line: 431


JTF_DIAGNOSTIC_COREAPI.insert_html('');

Line: 432


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

Line: 437


JTF_DIAGNOSTIC_COREAPI.insert_html('');

Line: 438


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

Line: 443


JTF_DIAGNOSTIC_COREAPI.insert_html('Inventory Information');

Line: 445


JTF_DIAGNOSTIC_COREAPI.insert_html('');

Line: 446


JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_MATERIAL_TRANSACTIONS_TEMP  
JTF_DIAGNOSTIC_COREAPI.insert_html('');

Line: 454


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

Line: 459


JTF_DIAGNOSTIC_COREAPI.insert_html('');

Line: 460


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

Line: 465


JTF_DIAGNOSTIC_COREAPI.insert_html('');

Line: 466


JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_TRANSACTION_LOT_NUMBERS  
JTF_DIAGNOSTIC_COREAPI.insert_html('');

Line: 473


JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_TRANSACTION_LOT_INTERFACE  
JTF_DIAGNOSTIC_COREAPI.insert_html('');

Line: 480


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

Line: 485


JTF_DIAGNOSTIC_COREAPI.insert_html('');

Line: 486


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

Line: 491


JTF_DIAGNOSTIC_COREAPI.insert_html('');

Line: 492


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

Line: 497


JTF_DIAGNOSTIC_COREAPI.insert_html('');

Line: 498


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

Line: 503


JTF_DIAGNOSTIC_COREAPI.insert_html('');

Line: 504


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

Line: 509


JTF_DIAGNOSTIC_COREAPI.insert_html('');

Line: 510


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

Line: 515


JTF_DIAGNOSTIC_COREAPI.insert_html('');

Line: 516


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

Line: 521


JTF_DIAGNOSTIC_COREAPI.insert_html('');

Line: 522


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

Line: 527


JTF_DIAGNOSTIC_COREAPI.insert_html('');

Line: 528


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

Line: 533


JTF_DIAGNOSTIC_COREAPI.insert_html('');

Line: 534


JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_SERIAL_NUMBERS_INTERFACE  
JTF_DIAGNOSTIC_COREAPI.insert_html('');

Line: 541


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

Line: 546


JTF_DIAGNOSTIC_COREAPI.insert_html('');

Line: 547


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

Line: 552


JTF_DIAGNOSTIC_COREAPI.insert_html('');

Line: 553


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

Line: 558


JTF_DIAGNOSTIC_COREAPI.insert_html('');

Line: 559


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

Line: 564


JTF_DIAGNOSTIC_COREAPI.insert_html('');

Line: 565


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

Line: 570


JTF_DIAGNOSTIC_COREAPI.insert_html('');

Line: 571


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

Line: 576


JTF_DIAGNOSTIC_COREAPI.insert_html('');

Line: 577


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

Line: 581


JTF_DIAGNOSTIC_COREAPI.insert_html('');

Line: 582


JTF_DIAGNOSTIC_COREAPI.insert_html('Lookup Codes');

Line: 584


JTF_DIAGNOSTIC_COREAPI.insert_html('');

Line: 585


JTF_DIAGNOSTIC_COREAPI.insert_html('Lot Control  [Top]');

Line: 590


JTF_DIAGNOSTIC_COREAPI.insert_html('');

Line: 591


JTF_DIAGNOSTIC_COREAPI.insert_html('Lot Generation  [Top]');

Line: 596


JTF_DIAGNOSTIC_COREAPI.insert_html('');

Line: 597


JTF_DIAGNOSTIC_COREAPI.insert_html('LOT Uniqueness  [Top]');

Line: 602


JTF_DIAGNOSTIC_COREAPI.insert_html('');

Line: 603


JTF_DIAGNOSTIC_COREAPI.insert_html('Serial Control  [Top]');

Line: 609


JTF_DIAGNOSTIC_COREAPI.insert_html('');

Line: 610


JTF_DIAGNOSTIC_COREAPI.insert_html('Serial Uniqueness  [Top]');

Line: 616


JTF_DIAGNOSTIC_COREAPI.insert_html('');

Line: 617


JTF_DIAGNOSTIC_COREAPI.insert_html('Serial Generation  [Top]');

Line: 622


JTF_DIAGNOSTIC_COREAPI.insert_html('');

Line: 623


JTF_DIAGNOSTIC_COREAPI.insert_html('Serial Number Status  [Top]');