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

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

Line: 111


  JTF_DIAGNOSTIC_COREAPI.insert_style_sheet;

Line: 161


SELECT Count(1)
INTO l_count
FROM po_headers_all ph,
po_lines_all pl,
po_line_locations_all pll,
rcv_shipment_headers rsh,
rcv_shipment_lines rsl
WHERE rsh.shipment_header_id=rsl.shipment_header_id
AND rsl.po_header_id=ph.po_header_id
AND rsl.po_line_id=pl.po_line_id
AND rsl.po_line_location_id=pll.line_location_id
AND pl.po_line_id=pll.po_line_id
AND pl.po_header_id=ph.po_header_id
AND pl.line_num=Nvl(l_line_num,pl.line_num)
AND pll.shipment_num=Nvl(l_line_loc_num,pll.shipment_num)
AND ph.segment1=l_po_number
AND ph.org_id=l_operating_id
AND rsh.receipt_num=l_receipt_num
AND rsh.ship_to_org_id=l_org_id;

Line: 192


SELECT Count(1)
INTO l_count
FROM po_headers_all ph,
rcv_shipment_headers rsh,
rcv_shipment_lines rsl
WHERE rsh.shipment_header_id=rsl.shipment_header_id
AND rsl.po_header_id=ph.po_header_id
AND ph.segment1=l_po_number
AND ph.org_id=l_operating_id
AND rsh.receipt_num=l_receipt_num
AND rsh.ship_to_org_id=l_org_id;

Line: 214


SELECT Count(1)
INTO l_count
FROM po_headers_all ph
where   ph.segment1=l_po_number
AND   ph.org_id=l_operating_id;

Line: 230


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: 284


JTF_DIAGNOSTIC_COREAPI.insert_html(''||'
'||'
'||'
'||'
'||'
'||'
'||'
'||'
'||'
'||'
'||'
'||'
'||'
'||'
'||'
'||'
'||'
'||'
'||'
'||'
'||'
'||'
'||'
'||'
'||'
'||'
'||'
'||'
'||'
'||'
'||'
'||'
'||'
'||'
'||'
'||'
'||'
'||'
'||'
'||'
'||'
'||'
'||'
'||'
'||'
'||'
'||'
'||'
'||'
'||'
'||'
'||'
'||'
'||'
'||'
'||'
'||'
'||'
'||'
'||'
'||'
'||'
'||'
'||'
'||'
'||'
'||'
'||'
'||'
'||'
'||'
'||'
'||'
'||'
INDEX OF QUERIES
PO_HEADERS_ALL PO_LINES_ALL PO_LINE_LOCATIONS_ALL
GL_CODE_COMBINATIONS RCV_RECEIVING_SUB_LEDGER AP_INVOICE_LINES_ALL
AP_INVOICES_ALL AP_INVOICE_LINES_INTERFACE AP_INVOICES_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_HEADERS_ALL	PO_LINES_ALL	PO_LINE_LOCATIONS_ALL
GL_CODE_COMBINATIONS	RCV_RECEIVING_SUB_LEDGER	AP_INVOICE_LINES_ALL
AP_INVOICES_ALL	AP_INVOICE_LINES_INTERFACE	AP_INVOICES_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: 363


JTF_DIAGNOSTIC_COREAPI.insert_html('Purchase Order Details');

Line: 365


JTF_DIAGNOSTIC_COREAPI.insert_html('');

Line: 366


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

Line: 371


JTF_DIAGNOSTIC_COREAPI.insert_html('');

Line: 372


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

Line: 377


JTF_DIAGNOSTIC_COREAPI.insert_html('');

Line: 378


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

Line: 383


JTF_DIAGNOSTIC_COREAPI.insert_html('');

Line: 384


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

Line: 389


JTF_DIAGNOSTIC_COREAPI.insert_html('Invoice Details');

Line: 390


JTF_DIAGNOSTIC_COREAPI.insert_html('');

Line: 391


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

Line: 396


JTF_DIAGNOSTIC_COREAPI.insert_html('');

Line: 397


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

Line: 402


JTF_DIAGNOSTIC_COREAPI.insert_html('');

Line: 403


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

Line: 408


JTF_DIAGNOSTIC_COREAPI.insert_html('');

Line: 409


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

Line: 414


JTF_DIAGNOSTIC_COREAPI.insert_html('');

Line: 415


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

Line: 420


JTF_DIAGNOSTIC_COREAPI.insert_html('');

Line: 421


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

Line: 427


JTF_DIAGNOSTIC_COREAPI.insert_html('Receipt Details');

Line: 428


JTF_DIAGNOSTIC_COREAPI.insert_html('');

Line: 429


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

Line: 434


JTF_DIAGNOSTIC_COREAPI.insert_html('');

Line: 435


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

Line: 440


JTF_DIAGNOSTIC_COREAPI.insert_html('');

Line: 441


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

Line: 446


JTF_DIAGNOSTIC_COREAPI.insert_html('');

Line: 447


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

Line: 452


JTF_DIAGNOSTIC_COREAPI.insert_html('');

Line: 453


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

Line: 458


JTF_DIAGNOSTIC_COREAPI.insert_html('');

Line: 459


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

Line: 464


JTF_DIAGNOSTIC_COREAPI.insert_html('');

Line: 465


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

Line: 470


JTF_DIAGNOSTIC_COREAPI.insert_html('');

Line: 471


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

Line: 477


JTF_DIAGNOSTIC_COREAPI.insert_html('Inventory Details');

Line: 478


JTF_DIAGNOSTIC_COREAPI.insert_html('');

Line: 479


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

Line: 484


JTF_DIAGNOSTIC_COREAPI.insert_html('');

Line: 485


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

Line: 490


JTF_DIAGNOSTIC_COREAPI.insert_html('');

Line: 491


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

Line: 496


JTF_DIAGNOSTIC_COREAPI.insert_html('');

Line: 497


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

Line: 502


JTF_DIAGNOSTIC_COREAPI.insert_html('');

Line: 503


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

Line: 509


JTF_DIAGNOSTIC_COREAPI.insert_html('Organization Setup Details');

Line: 510


JTF_DIAGNOSTIC_COREAPI.insert_html('');

Line: 511


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

Line: 516


JTF_DIAGNOSTIC_COREAPI.insert_html('');

Line: 517


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

Line: 522


JTF_DIAGNOSTIC_COREAPI.insert_html('');

Line: 523


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

Line: 528


JTF_DIAGNOSTIC_COREAPI.insert_html('');

Line: 529


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

Line: 534


JTF_DIAGNOSTIC_COREAPI.insert_html('');

Line: 535


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

Line: 541


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

Line: 542


JTF_DIAGNOSTIC_COREAPI.insert_html('');

Line: 543


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

Line: 548


JTF_DIAGNOSTIC_COREAPI.insert_html('');

Line: 549


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

Line: 554


JTF_DIAGNOSTIC_COREAPI.insert_html('');

Line: 555


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

Line: 560


JTF_DIAGNOSTIC_COREAPI.insert_html('');

Line: 561


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

Line: 566


JTF_DIAGNOSTIC_COREAPI.insert_html('');

Line: 567


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

Line: 572


JTF_DIAGNOSTIC_COREAPI.insert_html('');

Line: 573


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

Line: 578


JTF_DIAGNOSTIC_COREAPI.insert_html('');

Line: 579


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

Line: 584


JTF_DIAGNOSTIC_COREAPI.insert_html('');

Line: 585


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

Line: 590


JTF_DIAGNOSTIC_COREAPI.insert_html('');

Line: 591


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

Line: 596


JTF_DIAGNOSTIC_COREAPI.insert_html('');

Line: 597


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

Line: 602


JTF_DIAGNOSTIC_COREAPI.insert_html('');

Line: 603


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

Line: 608


JTF_DIAGNOSTIC_COREAPI.insert_html('');

Line: 609


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

Line: 614


JTF_DIAGNOSTIC_COREAPI.insert_html('');

Line: 615


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

Line: 620


JTF_DIAGNOSTIC_COREAPI.insert_html('');

Line: 621


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

Line: 625


JTF_DIAGNOSTIC_COREAPI.insert_html('');

Line: 626


JTF_DIAGNOSTIC_COREAPI.insert_html('Lookup Codes');

Line: 628


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

Line: 633


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

Line: 638


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

Line: 643


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

Line: 648


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

Line: 653


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

Line: 658


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