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_IO SQL Statements

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

Line: 111


 JTF_DIAGNOSTIC_COREAPI.insert_style_sheet;

Line: 133


     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 = 'INTERNAL ORDER';

Line: 150


     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 = 'INTERNAL ORDER';

Line: 239


      SELECT Count(*)
      INTO l_count
      FROM po_requisition_headers_all prh,
           po_requisition_lines_all prl,
           rcv_shipment_headers rsh,
           rcv_shipment_lines rsl
     WHERE prh.segment1 = l_req_num
     AND prh.org_id = l_ou_id
     AND prh.requisition_header_id = prl.requisition_header_id
     AND prl.line_num = l_line_num
     AND rsh.shipment_num = l_shipment_num
     AND rsh.receipt_num = l_receipt_num
     AND rsh.ship_to_org_id = l_org_id
     AND rsh.receipt_source_code = 'INTERNAL ORDER'
     AND prl.requisition_line_id = rsl.requisition_line_id;

Line: 268


      SELECT Count(*)
      INTO l_count
      FROM po_requisition_headers_all prh,
           po_requisition_lines_all prl,
           rcv_shipment_headers rsh,
           rcv_shipment_lines rsl
     WHERE prh.segment1 = l_req_num
     AND prh.org_id = l_ou_id
     AND prh.requisition_header_id = prl.requisition_header_id
     AND rsh.shipment_num = l_shipment_num
     AND rsh.receipt_num = l_receipt_num
     AND rsh.ship_to_org_id = l_org_id
     AND rsh.receipt_source_code = 'INTERNAL ORDER'
     AND prl.requisition_line_id = rsl.requisition_line_id;

Line: 294


      SELECT Count(*)
      INTO l_count
      FROM po_requisition_headers_all prh,
           po_requisition_lines_all prl
     WHERE prh.segment1 = l_req_num
     AND prh.org_id = l_ou_id
     AND prh.requisition_header_id = prl.requisition_header_id
     AND prl.line_num = l_line_num
     AND prl.source_type_code = 'INVENTORY';

Line: 315


      SELECT Count(*)
      INTO l_count
      FROM rcv_shipment_headers rsh,
           rcv_shipment_lines rsl
     WHERE rsh.shipment_num = l_shipment_num
     AND rsh.receipt_num = l_receipt_num
     AND rsh.ship_to_org_id = l_org_id
     AND rsh.receipt_source_code = 'INTERNAL ORDER';

Line: 335


      SELECT Count(*)
      INTO l_count
      FROM po_requisition_headers_all prh,
           po_requisition_lines_all prl
     WHERE prh.segment1 = l_req_num
     AND prh.org_id = l_ou_id
     AND prh.requisition_header_id = prl.requisition_header_id
     AND prl.source_type_code = 'INVENTORY';

Line: 355


      SELECT Count(*)
      INTO l_count
      FROM rcv_shipment_headers rsh,
           rcv_shipment_lines rsl
     WHERE rsh.receipt_num = l_receipt_num
     AND rsh.ship_to_org_id = l_org_id
     AND rsh.receipt_source_code = 'INTERNAL ORDER';

Line: 374


      SELECT Count(*)
      INTO l_count
      FROM rcv_shipment_headers rsh,
           rcv_shipment_lines rsl
     WHERE rsh.shipment_num = l_shipment_num
     AND rsh.ship_to_org_id = l_org_id
     AND rsh.receipt_source_code = 'INTERNAL ORDER';

Line: 457


JTF_DIAGNOSTIC_COREAPI.insert_html(''||'
'||'
'||'
'||'
'||'
'||'
'||'
'||'
'||'
'||'
'||'
'||'
'||'
'||'
'||'
'||'
'||'
'||'
'||'
'||'
'||'
'||'
'||'
'||'
'||'
'||'
'||'
'||'
'||'
'||'
'||'
'||'
'||'
'||'
'||'
'||'
'||'
'||'
'||'
'||'
'||'
'||'
'||'
'||'
'||'
'||'
'||'
'||'
'||'
'||'
'||'
'||'
'||'
'||'
'||'
'||'
'||'
'||'
'||'
'||'
'||'
'||'
'||'
'||'
'||'
'||'
'||'
'||'
'||'
'||'
'||'
'||'
INDEX OF QUERIES
PO_REQUISITION_HEADERS PO_REQUISITION_LINES PO_REQ_DISTRIBUTIONS
OE_ORDER_LINES WSH_DELIVERY_DETAILS RCV_SHIPMENT_HEADERS
RCV_SHIPMENT_LINES RCV_TRANSACTIONS MTL_SUPPLY
RCV_SUPPLY RCV_HEADERS_INTERFACE RCV_TRANSACTIONS_INTERFACE
PO_INTERFACE_ERRORS MTL_TRX_REQUEST_LINES MTL_TRANSACTIONS_INTERFACE
MTL_MATERIAL_TRANSACTIONS_TEMP MTL_MATERIAL_TRANSACTIONS MTL_RESERVATIONS
MTL_DEMAND MTL_SYSTEM_ITEMS MTL_SERIAL_NUMBERS
MTL_SERIAL_NUMBERS_TEMP MTL_SERIAL_NUMBERS_INTERFACE MTL_UNIT_TRANSACTIONS
RCV_SERIALS_SUPPLY RCV_SERIAL_TRANSACTIONS RCV_SERIALS_INTERFACE
MTL_LOT_NUMBERS MTL_TRANSACTION_LOT_NUMBERS MTL_TRANSACTION_LOTS_INTERFACE
MTL_TRANSACTION_LOTS_TEMP RCV_LOTS_SUPPLY RCV_LOT_TRANSACTIONS
RCV_LOTS_INTERFACE MTL_TRANSACTION_TYPES ORG_ORGANIZATION_DEFINITIONS
MTL_PARAMETERS MTL_INTERORG_PARAMETERS RCV_PARAMETERS
LOOKUP CODES');

INDEX OF QUERIES
PO_REQUISITION_HEADERS	PO_REQUISITION_LINES	PO_REQ_DISTRIBUTIONS
OE_ORDER_LINES	WSH_DELIVERY_DETAILS	RCV_SHIPMENT_HEADERS
RCV_SHIPMENT_LINES	RCV_TRANSACTIONS	MTL_SUPPLY
RCV_SUPPLY	RCV_HEADERS_INTERFACE	RCV_TRANSACTIONS_INTERFACE
PO_INTERFACE_ERRORS	MTL_TRX_REQUEST_LINES	MTL_TRANSACTIONS_INTERFACE
MTL_MATERIAL_TRANSACTIONS_TEMP	MTL_MATERIAL_TRANSACTIONS	MTL_RESERVATIONS
MTL_DEMAND	MTL_SYSTEM_ITEMS	MTL_SERIAL_NUMBERS
MTL_SERIAL_NUMBERS_TEMP	MTL_SERIAL_NUMBERS_INTERFACE	MTL_UNIT_TRANSACTIONS
RCV_SERIALS_SUPPLY	RCV_SERIAL_TRANSACTIONS	RCV_SERIALS_INTERFACE
MTL_LOT_NUMBERS	MTL_TRANSACTION_LOT_NUMBERS	MTL_TRANSACTION_LOTS_INTERFACE
MTL_TRANSACTION_LOTS_TEMP	RCV_LOTS_SUPPLY	RCV_LOT_TRANSACTIONS
RCV_LOTS_INTERFACE	MTL_TRANSACTION_TYPES	ORG_ORGANIZATION_DEFINITIONS
MTL_PARAMETERS	MTL_INTERORG_PARAMETERS	RCV_PARAMETERS
LOOKUP CODES

Line: 531


JTF_DIAGNOSTIC_COREAPI.insert_html('Requisition Details');

Line: 533


JTF_DIAGNOSTIC_COREAPI.insert_html('');

Line: 534


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

Line: 539


JTF_DIAGNOSTIC_COREAPI.insert_html('');

Line: 540


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

Line: 545


JTF_DIAGNOSTIC_COREAPI.insert_html('');

Line: 546


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

Line: 550


JTF_DIAGNOSTIC_COREAPI.insert_html('Shipping Details');

Line: 552


JTF_DIAGNOSTIC_COREAPI.insert_html('');

Line: 553


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

Line: 558


JTF_DIAGNOSTIC_COREAPI.insert_html('');

Line: 559


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

Line: 563


JTF_DIAGNOSTIC_COREAPI.insert_html('Receipt Details');

Line: 565


JTF_DIAGNOSTIC_COREAPI.insert_html('');

Line: 566


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

Line: 571


JTF_DIAGNOSTIC_COREAPI.insert_html('');

Line: 572


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

Line: 577


JTF_DIAGNOSTIC_COREAPI.insert_html('');

Line: 578


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

Line: 583


JTF_DIAGNOSTIC_COREAPI.insert_html('');

Line: 584


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

Line: 589


JTF_DIAGNOSTIC_COREAPI.insert_html('');

Line: 590


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

Line: 595


JTF_DIAGNOSTIC_COREAPI.insert_html('');

Line: 596


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

Line: 601


JTF_DIAGNOSTIC_COREAPI.insert_html('');

Line: 602


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

Line: 607


JTF_DIAGNOSTIC_COREAPI.insert_html('');

Line: 608


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

Line: 612


JTF_DIAGNOSTIC_COREAPI.insert_html('Inventory Details');

Line: 614


JTF_DIAGNOSTIC_COREAPI.insert_html('');

Line: 615


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

Line: 620


JTF_DIAGNOSTIC_COREAPI.insert_html('');

Line: 621


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

Line: 626


JTF_DIAGNOSTIC_COREAPI.insert_html('');

Line: 627


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

Line: 632


JTF_DIAGNOSTIC_COREAPI.insert_html('');

Line: 633


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

Line: 638


JTF_DIAGNOSTIC_COREAPI.insert_html('');

Line: 639


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

Line: 644


JTF_DIAGNOSTIC_COREAPI.insert_html('');

Line: 645


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

Line: 650


JTF_DIAGNOSTIC_COREAPI.insert_html('');

Line: 651


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

Line: 655


JTF_DIAGNOSTIC_COREAPI.insert_html('Lot and Serial Transaction Details');

Line: 657


JTF_DIAGNOSTIC_COREAPI.insert_html('');

Line: 658


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

Line: 663


JTF_DIAGNOSTIC_COREAPI.insert_html('');

Line: 664


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

Line: 669


JTF_DIAGNOSTIC_COREAPI.insert_html('');

Line: 670


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

Line: 675


JTF_DIAGNOSTIC_COREAPI.insert_html('');

Line: 676


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

Line: 681


JTF_DIAGNOSTIC_COREAPI.insert_html('');

Line: 682


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

Line: 687


JTF_DIAGNOSTIC_COREAPI.insert_html('');

Line: 688


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

Line: 693


JTF_DIAGNOSTIC_COREAPI.insert_html('');

Line: 694


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

Line: 699


JTF_DIAGNOSTIC_COREAPI.insert_html('');

Line: 700


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

Line: 705


JTF_DIAGNOSTIC_COREAPI.insert_html('');

Line: 706


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

Line: 711


JTF_DIAGNOSTIC_COREAPI.insert_html('');

Line: 712


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

Line: 717


JTF_DIAGNOSTIC_COREAPI.insert_html('');

Line: 718


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

Line: 723


JTF_DIAGNOSTIC_COREAPI.insert_html('');

Line: 724


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

Line: 729


JTF_DIAGNOSTIC_COREAPI.insert_html('');

Line: 730


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

Line: 735


JTF_DIAGNOSTIC_COREAPI.insert_html('');

Line: 736


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

Line: 741


JTF_DIAGNOSTIC_COREAPI.insert_html('');

Line: 742


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

Line: 746


JTF_DIAGNOSTIC_COREAPI.insert_html('Organization Setup Details');

Line: 748


JTF_DIAGNOSTIC_COREAPI.insert_html('');

Line: 749


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

Line: 754


JTF_DIAGNOSTIC_COREAPI.insert_html('');

Line: 755


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

Line: 760


JTF_DIAGNOSTIC_COREAPI.insert_html('');

Line: 761


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

Line: 766


JTF_DIAGNOSTIC_COREAPI.insert_html('');

Line: 767


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

Line: 771


JTF_DIAGNOSTIC_COREAPI.insert_html('');

Line: 772


JTF_DIAGNOSTIC_COREAPI.insert_html('Lookup Codes');

Line: 774


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

Line: 779


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

Line: 784


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

Line: 789


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

Line: 794


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

Line: 799


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

Line: 804


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