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

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

Line: 109


  JTF_DIAGNOSTIC_COREAPI.insert_style_sheet;

Line: 159


SELECT Count(1)
INTO l_count
FROM po_requisition_headers_all prh,
po_requisition_lines_all prl,
rcv_shipment_headers rsh,
rcv_shipment_lines rsl,
po_line_locations_all pll ,
po_distributions_all pd,
po_req_distributions_all prd
WHERE   prh.type_lookup_code IN ('PURCHASE','INTERNAL')
and prh.requisition_header_id = prl.requisition_header_id
and prl.requisition_line_id = prd.requisition_line_id
AND prl.line_num=Nvl(l_line_num,prl.line_num)
and prl.source_type_code = 'VENDOR'
and pd.req_distribution_id = prd.distribution_id
and rsl.po_line_location_id=pll.line_location_id
AND rsl.shipment_header_id = rsh.shipment_header_id
AND pll.line_location_id = pd.line_location_id
AND prh.segment1=l_req_number
AND prh.org_id=l_operating_id
AND rsh.receipt_num=l_receipt_num
AND rsh.ship_to_org_id=l_org_id;

Line: 193


SELECT Count(1)
INTO l_count
FROM po_requisition_headers_all prh,
po_requisition_lines_all prl
WHERE prh.type_lookup_code IN ('PURCHASE','INTERNAL')
and prh.requisition_header_id = prl.requisition_header_id
and   prh.segment1=l_req_number
AND   prh.org_id=l_operating_id;

Line: 213


SELECT Count(1)
INTO l_count
FROM rcv_shipment_headers rsh
WHERE receipt_source_code='VENDOR'
AND rsh.receipt_num=l_receipt_num
AND rsh.ship_to_org_id=l_org_id;

Line: 265


JTF_DIAGNOSTIC_COREAPI.insert_html(''||'
'||'
'||'
'||'
'||'
'||'
'||'
'||'
'||'
'||'
'||'
'||'
'||'
'||'
'||'
'||'
'||'
'||'
'||'
'||'
'||'
'||'
'||'
'||'
'||'
'||'
'||'
'||'
'||'
'||'
'||'
'||'
'||'
'||'
'||'
'||'
'||'
'||'
'||'
'||'
'||'
'||'
'||'
'||'
'||'
'||'
'||'
'||'
'||'
'||'
'||'
'||'
'||'
'||'
'||'
'||'
'||'
'||'
'||'
'||'
'||'
'||'
'||'
'||'
'||'
'||'
'||'
'||'
'||'
'||'
'||'
'||'
'||'
'||'
'||'
'||'
'||'
'||'
'||'
'||'
'||'
'||'
INDEX OF QUERIES
PO_REQUISITION_HEADERS_ALL PO_REQUISITION_LINES_ALL PO_REQ_DISTRIBUTIONS_ALL
PO_HEADERS_ALL PO_LINES_ALL PO_LINE_LOCATIONS_ALL
PO_DISTRIBUTIONS_ALL GL_CODE_COMBINATIONS RCV_RECEIVING_SUB_LEDGER
AP_INVOICE_LINES_ALL AP_INVOICES_ALL AP_INVOICES_INTERFACE
AP_INVOICE_LINES_INTERFACE RCV_SHIPMENT_HEADERS RCV_SHIPMENT_LINES
RCV_TRANSACTIONS MTL_SUPPLY RCV_SUPPLY
RCV_HEADERS_INTERFACE RCV_TRANSACTIONS_INTERFACE PO_INTERFACE_ERRORS
MTL_SYSTEM_ITEMS MTL_MATERIAL_TRANSACTIONS MTL_TRANSACTION_TYPES
MTL_TXN_REQUEST_LINES MTL_MATERIAL_TRANSACTIONS_TEMP ORG_ORGANIZATION_DEFINITIONS
MTL_PARAMETERS RCV_PARAMETERS PO_SYSTEM_PARAMETERS_ALL
FINANCIALS_SYSTEM_PARAMS_ALL 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
LOOKUP CODES');

INDEX OF QUERIES
PO_REQUISITION_HEADERS_ALL	PO_REQUISITION_LINES_ALL	PO_REQ_DISTRIBUTIONS_ALL
PO_HEADERS_ALL	PO_LINES_ALL	PO_LINE_LOCATIONS_ALL
PO_DISTRIBUTIONS_ALL	GL_CODE_COMBINATIONS	RCV_RECEIVING_SUB_LEDGER
AP_INVOICE_LINES_ALL	AP_INVOICES_ALL	AP_INVOICES_INTERFACE
AP_INVOICE_LINES_INTERFACE	RCV_SHIPMENT_HEADERS	RCV_SHIPMENT_LINES
RCV_TRANSACTIONS	MTL_SUPPLY	RCV_SUPPLY
RCV_HEADERS_INTERFACE	RCV_TRANSACTIONS_INTERFACE	PO_INTERFACE_ERRORS
MTL_SYSTEM_ITEMS	MTL_MATERIAL_TRANSACTIONS	MTL_TRANSACTION_TYPES
MTL_TXN_REQUEST_LINES	MTL_MATERIAL_TRANSACTIONS_TEMP	ORG_ORGANIZATION_DEFINITIONS
MTL_PARAMETERS	RCV_PARAMETERS	PO_SYSTEM_PARAMETERS_ALL
FINANCIALS_SYSTEM_PARAMS_ALL	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
LOOKUP CODES

Line: 352


JTF_DIAGNOSTIC_COREAPI.insert_html('Requisition Details');

Line: 354


JTF_DIAGNOSTIC_COREAPI.insert_html('');

Line: 355


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

Line: 360


JTF_DIAGNOSTIC_COREAPI.insert_html('');

Line: 361


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

Line: 366


JTF_DIAGNOSTIC_COREAPI.insert_html('');

Line: 367


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

Line: 373


JTF_DIAGNOSTIC_COREAPI.insert_html('Purchase Order Details');

Line: 374


JTF_DIAGNOSTIC_COREAPI.insert_html('');

Line: 375


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

Line: 380


JTF_DIAGNOSTIC_COREAPI.insert_html('');

Line: 381


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

Line: 386


JTF_DIAGNOSTIC_COREAPI.insert_html('');

Line: 387


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

Line: 392


JTF_DIAGNOSTIC_COREAPI.insert_html('');

Line: 393


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

Line: 399


JTF_DIAGNOSTIC_COREAPI.insert_html('Invoice Details');

Line: 400


JTF_DIAGNOSTIC_COREAPI.insert_html('');

Line: 401


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

Line: 406


JTF_DIAGNOSTIC_COREAPI.insert_html('');

Line: 407


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

Line: 412


JTF_DIAGNOSTIC_COREAPI.insert_html('');

Line: 413


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

Line: 418


JTF_DIAGNOSTIC_COREAPI.insert_html('');

Line: 419


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

Line: 424


JTF_DIAGNOSTIC_COREAPI.insert_html('');

Line: 425


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

Line: 430


JTF_DIAGNOSTIC_COREAPI.insert_html('');

Line: 431


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

Line: 437


JTF_DIAGNOSTIC_COREAPI.insert_html('Receipt Details');

Line: 438


JTF_DIAGNOSTIC_COREAPI.insert_html('');

Line: 439


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

Line: 444


JTF_DIAGNOSTIC_COREAPI.insert_html('');

Line: 445


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

Line: 450


JTF_DIAGNOSTIC_COREAPI.insert_html('');

Line: 451


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

Line: 456


JTF_DIAGNOSTIC_COREAPI.insert_html('');

Line: 457


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

Line: 462


JTF_DIAGNOSTIC_COREAPI.insert_html('');

Line: 463


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

Line: 468


JTF_DIAGNOSTIC_COREAPI.insert_html('');

Line: 469


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

Line: 474


JTF_DIAGNOSTIC_COREAPI.insert_html('');

Line: 475


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

Line: 480


JTF_DIAGNOSTIC_COREAPI.insert_html('');

Line: 481


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

Line: 487


JTF_DIAGNOSTIC_COREAPI.insert_html('Inventory Details');

Line: 488


JTF_DIAGNOSTIC_COREAPI.insert_html('');

Line: 489


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

Line: 494


JTF_DIAGNOSTIC_COREAPI.insert_html('');

Line: 495


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

Line: 500


JTF_DIAGNOSTIC_COREAPI.insert_html('');

Line: 501


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

Line: 506


JTF_DIAGNOSTIC_COREAPI.insert_html('');

Line: 507


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

Line: 512


JTF_DIAGNOSTIC_COREAPI.insert_html('');

Line: 513


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

Line: 519


JTF_DIAGNOSTIC_COREAPI.insert_html('Organization Setup Details');

Line: 520


JTF_DIAGNOSTIC_COREAPI.insert_html('');

Line: 521


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

Line: 526


JTF_DIAGNOSTIC_COREAPI.insert_html('');

Line: 527


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

Line: 532


JTF_DIAGNOSTIC_COREAPI.insert_html('');

Line: 533


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

Line: 538


JTF_DIAGNOSTIC_COREAPI.insert_html('');

Line: 539


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

Line: 544


JTF_DIAGNOSTIC_COREAPI.insert_html('');

Line: 545


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

Line: 551


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

Line: 552


JTF_DIAGNOSTIC_COREAPI.insert_html('');

Line: 553


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

Line: 558


JTF_DIAGNOSTIC_COREAPI.insert_html('');

Line: 559


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

Line: 564


JTF_DIAGNOSTIC_COREAPI.insert_html('');

Line: 565


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

Line: 570


JTF_DIAGNOSTIC_COREAPI.insert_html('');

Line: 571


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

Line: 576


JTF_DIAGNOSTIC_COREAPI.insert_html('');

Line: 577


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

Line: 582


JTF_DIAGNOSTIC_COREAPI.insert_html('');

Line: 583


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

Line: 588


JTF_DIAGNOSTIC_COREAPI.insert_html('');

Line: 589


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

Line: 594


JTF_DIAGNOSTIC_COREAPI.insert_html('');

Line: 595


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

Line: 600


JTF_DIAGNOSTIC_COREAPI.insert_html('');

Line: 601


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

Line: 606


JTF_DIAGNOSTIC_COREAPI.insert_html('');

Line: 607


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

Line: 612


JTF_DIAGNOSTIC_COREAPI.insert_html('');

Line: 613


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

Line: 618


JTF_DIAGNOSTIC_COREAPI.insert_html('');

Line: 619


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

Line: 624


JTF_DIAGNOSTIC_COREAPI.insert_html('');

Line: 625


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

Line: 630


JTF_DIAGNOSTIC_COREAPI.insert_html('');

Line: 631


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

Line: 636


JTF_DIAGNOSTIC_COREAPI.insert_html('');

Line: 637


JTF_DIAGNOSTIC_COREAPI.insert_html('Lookup Codes');

Line: 639


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

Line: 644


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

Line: 649


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

Line: 654


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

Line: 659


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

Line: 664


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

Line: 669


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