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.RCV_ROI_HEADER_COMMON dependencies on PO_HEADERS

Line 743: FROM po_headers

739: AND x_document_num IS NOT NULL) THEN
740: BEGIN -- bugfix 4070516
741: SELECT po_header_id
742: INTO x_po_header_id
743: FROM po_headers
744: WHERE segment1 = x_document_num
745: AND type_lookup_code IN('STANDARD', 'BLANKET', 'PLANNED');
746: -- Following exception handling block is added for bugfix 4070516
747: EXCEPTION

Line 1250: --Bug5263268:Cursor to fetch the value of "Shipping_control" from po_headers table.

1246: po_line_location_id po_shipment_line_id
1247: FROM rcv_transactions_interface
1248: WHERE header_interface_id = p_header_record.header_record.header_interface_id;
1249:
1250: --Bug5263268:Cursor to fetch the value of "Shipping_control" from po_headers table.
1251: --Note:-ASN or ASBN can be created for multiple PO's provided they have the same
1252: --value for shing control.It is not possible to create a single ASN or ASBN with one PO
1253: --having shipping control as 'buyer' and another PO with shipping control as 'supplier' or
1254: --shippign control is null.

Line 1259: from po_headers_all

1255: --So there is no need to loop through the records fetched by the cursor.
1256:
1257: /*CURSOR c_get_shipping_control is
1258: select shipping_control
1259: from po_headers_all
1260: where po_header_id = (select po_header_id
1261: from rcv_transactions_interface
1262: where header_interface_id = p_header_record.header_record.header_interface_id
1263: and rownum=1);*/ --Bugfix 5844039