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 1193: --Bug5263268:Cursor to fetch the value of "Shipping_control" from po_headers table.

1189: po_line_location_id po_shipment_line_id
1190: FROM rcv_transactions_interface
1191: WHERE header_interface_id = p_header_record.header_record.header_interface_id;
1192:
1193: --Bug5263268:Cursor to fetch the value of "Shipping_control" from po_headers table.
1194: --Note:-ASN or ASBN can be created for multiple PO's provided they have the same
1195: --value for shing control.It is not possible to create a single ASN or ASBN with one PO
1196: --having shipping control as 'buyer' and another PO with shipping control as 'supplier' or
1197: --shippign control is null.

Line 1202: from po_headers_all

1198: --So there is no need to loop through the records fetched by the cursor.
1199:
1200: CURSOR c_get_shipping_control is
1201: select shipping_control
1202: from po_headers_all
1203: where po_header_id = (select po_header_id
1204: from rcv_transactions_interface
1205: where header_interface_id = p_header_record.header_record.header_interface_id
1206: and rownum=1); --Bugfix 5844039