The following lines contain the word 'select', 'insert', 'update' or 'delete':
JTF_DIAGNOSTIC_COREAPI.insert_style_sheet;
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';
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';
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';
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';
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';
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';
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';
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';
JTF_DIAGNOSTIC_COREAPI.insert_style_sheet;
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 '||'
'||'
');
JTF_DIAGNOSTIC_COREAPI.insert_html('Receipt Information
');
JTF_DIAGNOSTIC_COREAPI.insert_html('');
JTF_DIAGNOSTIC_COREAPI.insert_html('RCV_HEADERS_INTERFACE [Top]');
JTF_DIAGNOSTIC_COREAPI.insert_html('');
JTF_DIAGNOSTIC_COREAPI.insert_html('RCV_TRANSACTIONS_INTERFACE
JTF_DIAGNOSTIC_COREAPI.insert_html('');
JTF_DIAGNOSTIC_COREAPI.insert_html('PO_INTERFACE_ERRORS [Top]');
JTF_DIAGNOSTIC_COREAPI.insert_html('');
JTF_DIAGNOSTIC_COREAPI.insert_html('RCV_SHIPMENT_HEADERS [Top]');
JTF_DIAGNOSTIC_COREAPI.insert_html('');
JTF_DIAGNOSTIC_COREAPI.insert_html('RCV_SHIPMENT_LINES [Top]');
JTF_DIAGNOSTIC_COREAPI.insert_html('');
JTF_DIAGNOSTIC_COREAPI.insert_html('RCV_TRANSACTIONS [Top]');
JTF_DIAGNOSTIC_COREAPI.insert_html('');
JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_SUPPLY [Top]');
JTF_DIAGNOSTIC_COREAPI.insert_html('');
JTF_DIAGNOSTIC_COREAPI.insert_html('RCV_SUPPLY [Top]');
JTF_DIAGNOSTIC_COREAPI.insert_html('Inventory Information
');
JTF_DIAGNOSTIC_COREAPI.insert_html('');
JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_MATERIAL_TRANSACTIONS_TEMP
JTF_DIAGNOSTIC_COREAPI.insert_html('');
JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_MATERIAL_TRANSACTIONS [Top]');
JTF_DIAGNOSTIC_COREAPI.insert_html('');
JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_LOT_NUMBERS [Top]');
JTF_DIAGNOSTIC_COREAPI.insert_html('');
JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_TRANSACTION_LOT_NUMBERS
JTF_DIAGNOSTIC_COREAPI.insert_html('');
JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_TRANSACTION_LOT_INTERFACE
JTF_DIAGNOSTIC_COREAPI.insert_html('');
JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_TRANSACTION_LOTS_TEMP [Top]');
JTF_DIAGNOSTIC_COREAPI.insert_html('');
JTF_DIAGNOSTIC_COREAPI.insert_html('RCV_LOTS_SUPPLY [Top]');
JTF_DIAGNOSTIC_COREAPI.insert_html('');
JTF_DIAGNOSTIC_COREAPI.insert_html('RCV_LOT_TRANSACTIONS [Top]');
JTF_DIAGNOSTIC_COREAPI.insert_html('');
JTF_DIAGNOSTIC_COREAPI.insert_html('RCV_LOTS_INTERFACE [Top]');
JTF_DIAGNOSTIC_COREAPI.insert_html('');
JTF_DIAGNOSTIC_COREAPI.insert_html('RCV_SERIAL_SUPPLY [Top]');
JTF_DIAGNOSTIC_COREAPI.insert_html('');
JTF_DIAGNOSTIC_COREAPI.insert_html('RCV_SERIAL_TRANSACTIONS [Top]');
JTF_DIAGNOSTIC_COREAPI.insert_html('');
JTF_DIAGNOSTIC_COREAPI.insert_html('RCV_SERIALS_INTERFACE [Top]');
JTF_DIAGNOSTIC_COREAPI.insert_html('');
JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_SERIAL_NUMBERS [Top]');
JTF_DIAGNOSTIC_COREAPI.insert_html('');
JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_SERIAL_NUMBERS_TEMP [Top]');
JTF_DIAGNOSTIC_COREAPI.insert_html('');
JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_SERIAL_NUMBERS_INTERFACE
JTF_DIAGNOSTIC_COREAPI.insert_html('');
JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_UNIT_TRANSACTIONS [Top]');
JTF_DIAGNOSTIC_COREAPI.insert_html('');
JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_SYSTEM_ITEMS [Top]');
JTF_DIAGNOSTIC_COREAPI.insert_html('');
JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_TRANSACTION_TYPES [Top]');
JTF_DIAGNOSTIC_COREAPI.insert_html('');
JTF_DIAGNOSTIC_COREAPI.insert_html('ORG_ORG_DEFINITIONS [Top]');
JTF_DIAGNOSTIC_COREAPI.insert_html('');
JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_INTERORG_PARAMETERS [Top]');
JTF_DIAGNOSTIC_COREAPI.insert_html('');
JTF_DIAGNOSTIC_COREAPI.insert_html('MTL_PARAMETERS [Top]');
JTF_DIAGNOSTIC_COREAPI.insert_html('');
JTF_DIAGNOSTIC_COREAPI.insert_html('RCV_PARAMETERS [Top]');
JTF_DIAGNOSTIC_COREAPI.insert_html('');
JTF_DIAGNOSTIC_COREAPI.insert_html('Lookup Codes
');
JTF_DIAGNOSTIC_COREAPI.insert_html('');
JTF_DIAGNOSTIC_COREAPI.insert_html('Lot Control [Top]');
JTF_DIAGNOSTIC_COREAPI.insert_html('');
JTF_DIAGNOSTIC_COREAPI.insert_html('Lot Generation [Top]');
JTF_DIAGNOSTIC_COREAPI.insert_html('');
JTF_DIAGNOSTIC_COREAPI.insert_html('LOT Uniqueness [Top]');
JTF_DIAGNOSTIC_COREAPI.insert_html('');
JTF_DIAGNOSTIC_COREAPI.insert_html('Serial Control [Top]');
JTF_DIAGNOSTIC_COREAPI.insert_html('');
JTF_DIAGNOSTIC_COREAPI.insert_html('Serial Uniqueness [Top]');
JTF_DIAGNOSTIC_COREAPI.insert_html('');
JTF_DIAGNOSTIC_COREAPI.insert_html('Serial Generation [Top]');
JTF_DIAGNOSTIC_COREAPI.insert_html('');
JTF_DIAGNOSTIC_COREAPI.insert_html('Serial Number Status [Top]');