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 RCV_TRANSACTIONS_INTERFACE

Line 30: ** to pull it off the rcv_transactions_interface to_organization_code or

26: * organization_id is uk. org_organization_definitions is a view */
27: IF p_header_record.error_record.error_status IN('S', 'W') THEN
28: /*
29: ** If the shipment header ship to organization code is null then try
30: ** to pull it off the rcv_transactions_interface to_organization_code or
31: ** the ship_to_location_code.
32: */
33: IF ( p_header_record.header_record.ship_to_organization_code IS NULL
34: AND p_header_record.header_record.ship_to_organization_id IS NULL) THEN

Line 247: x_shipment_header_id RCV_TRANSACTIONS_INTERFACE.SHIPMENT_HEADER_ID%TYPE;

243: ) IS
244: x_header_interface_id NUMBER;
245: x_to_organization_code VARCHAR2(3);
246: x_to_organization_id NUMBER; /* Bug#3909973 - (1) */
247: x_shipment_header_id RCV_TRANSACTIONS_INTERFACE.SHIPMENT_HEADER_ID%TYPE;
248: x_shipment_num RCV_TRANSACTIONS_INTERFACE.SHIPMENT_NUM%TYPE;
249: x_document_num RCV_TRANSACTIONS_INTERFACE.DOCUMENT_NUM%TYPE;
250: BEGIN
251: x_header_interface_id := p_header_record.header_record.header_interface_id;

Line 248: x_shipment_num RCV_TRANSACTIONS_INTERFACE.SHIPMENT_NUM%TYPE;

244: x_header_interface_id NUMBER;
245: x_to_organization_code VARCHAR2(3);
246: x_to_organization_id NUMBER; /* Bug#3909973 - (1) */
247: x_shipment_header_id RCV_TRANSACTIONS_INTERFACE.SHIPMENT_HEADER_ID%TYPE;
248: x_shipment_num RCV_TRANSACTIONS_INTERFACE.SHIPMENT_NUM%TYPE;
249: x_document_num RCV_TRANSACTIONS_INTERFACE.DOCUMENT_NUM%TYPE;
250: BEGIN
251: x_header_interface_id := p_header_record.header_record.header_interface_id;
252:

Line 249: x_document_num RCV_TRANSACTIONS_INTERFACE.DOCUMENT_NUM%TYPE;

245: x_to_organization_code VARCHAR2(3);
246: x_to_organization_id NUMBER; /* Bug#3909973 - (1) */
247: x_shipment_header_id RCV_TRANSACTIONS_INTERFACE.SHIPMENT_HEADER_ID%TYPE;
248: x_shipment_num RCV_TRANSACTIONS_INTERFACE.SHIPMENT_NUM%TYPE;
249: x_document_num RCV_TRANSACTIONS_INTERFACE.DOCUMENT_NUM%TYPE;
250: BEGIN
251: x_header_interface_id := p_header_record.header_record.header_interface_id;
252:
253: IF (g_asn_debug = 'Y') THEN

Line 260: FROM rcv_transactions_interface rti

256: END IF;
257:
258: SELECT MAX(rti.to_organization_code)
259: INTO x_to_organization_code
260: FROM rcv_transactions_interface rti
261: WHERE rti.header_interface_id = x_header_interface_id;
262:
263: /* Bug# 1465730 - If Ship To Organization Code is not specified at lines
264: * then derive it from the To Organization Id and if this is also not

Line 276: FROM RCV_TRANSACTIONS_INTERFACE RTI,

272:
273: /* ksareddy RVCTP performance fix 2481798 - select from mtl_parameters instead
274: SELECT MAX(ORG.ORGANIZATION_CODE)
275: INTO X_TO_ORGANIZATION_CODE
276: FROM RCV_TRANSACTIONS_INTERFACE RTI,
277: ORG_ORGANIZATION_DEFINITIONS ORG
278: WHERE RTI.HEADER_INTERFACE_ID = X_HEADER_INTERFACE_ID
279: AND ORG.ORGANIZATION_ID = RTI.TO_ORGANIZATION_ID;
280: */

Line 283: FROM rcv_transactions_interface rti,

279: AND ORG.ORGANIZATION_ID = RTI.TO_ORGANIZATION_ID;
280: */
281: SELECT MAX(mtl.organization_code)
282: INTO x_to_organization_code
283: FROM rcv_transactions_interface rti,
284: mtl_parameters mtl
285: WHERE rti.header_interface_id = x_header_interface_id
286: AND mtl.organization_id = rti.to_organization_id;
287: END IF;

Line 296: FROM rcv_transactions_interface rti,

292: END IF;
293:
294: SELECT MAX(org.organization_code)
295: INTO x_to_organization_code
296: FROM rcv_transactions_interface rti,
297: hr_locations hl,
298: mtl_parameters org
299: -- BugFix 5219284, replaced org_organization_definitions with mtl_parameters for better performance.
300: WHERE rti.header_interface_id = x_header_interface_id

Line 314: FROM rcv_transactions_interface rti

310: END IF;
311:
312: SELECT MAX(rti.shipment_header_id),MAX(rti.shipment_num),MAX(rti.document_num)
313: INTO x_shipment_header_id,x_shipment_num,x_document_num
314: FROM rcv_transactions_interface rti
315: WHERE rti.header_interface_id = x_header_interface_id;
316:
317: x_shipment_num := nvl(x_shipment_num,p_header_record.header_record.shipment_num);
318:

Line 403: entered in rcv_transactions_interface.

399: END;
400: END IF; -- set primary_uom
401:
402: /* Bug 2020269 : uom_code needs to be derived from unit_of_measure
403: entered in rcv_transactions_interface.
404: */
405: IF (x_cascaded_table(n).unit_of_measure IS NOT NULL) THEN
406: IF (g_asn_debug = 'Y') THEN
407: asn_debug.put_line('deriving uom_code from unit_of_measure');

Line 628: FROM rcv_transactions_interface rti

624: IF p_header_record.header_record.receipt_num IS NULL
625: AND p_header_record.header_record.transaction_type <> 'CANCEL' THEN -- added for support of cancel
626: SELECT COUNT(*)
627: INTO v_count
628: FROM rcv_transactions_interface rti
629: WHERE rti.header_interface_id = p_header_record.header_record.header_interface_id
630: AND ( rti.auto_transact_code IN('RECEIVE', 'DELIVER')
631: OR rti.transaction_type IN('RECEIVE', 'DELIVER'));
632:

Line 735: FROM rcv_transactions_interface rti

731: SELECT MAX(rti.po_header_id),
732: MAX(document_num)
733: INTO x_po_header_id,
734: x_document_num
735: FROM rcv_transactions_interface rti
736: WHERE rti.header_interface_id = p_header_record.header_record.header_interface_id;
737:
738: IF ( x_po_header_id IS NULL
739: AND x_document_num IS NOT NULL) THEN

Line 973: FROM rcv_transactions_interface rti,

969: END IF;
970:
971: SELECT COUNT(*)
972: INTO x_count
973: FROM rcv_transactions_interface rti,
974: rcv_headers_interface rhi
975: WHERE rti.header_interface_id = p_header_record.header_record.header_interface_id
976: AND rhi.header_interface_id = rti.header_interface_id
977: AND ( ( rti.to_organization_code IS NOT NULL

Line 1006: FROM rcv_transactions_interface rti,

1002: during the line level organization derivation.
1003: */
1004: SELECT COUNT(*)
1005: INTO x_count
1006: FROM rcv_transactions_interface rti,
1007: hr_locations hl,
1008: mtl_parameters org
1009: -- BugFix 5219284, replaced org_organization_definitions with mtl_parameters for better performance.
1010: WHERE rti.header_interface_id = p_header_record.header_record.header_interface_id

Line 1032: FROM rcv_transactions_interface rti,

1028: */
1029: IF x_count = 0 THEN
1030: SELECT COUNT(*)
1031: INTO x_count
1032: FROM rcv_transactions_interface rti,
1033: hr_locations hl,
1034: mtl_parameters org
1035: -- BugFix 5219284, replaced org_organization_definitions with mtl_parameters for better performance.
1036: WHERE rti.header_interface_id = p_header_record.header_record.header_interface_id

Line 1190: FROM rcv_transactions_interface

1186:
1187: CURSOR get_lines IS
1188: SELECT po_line_id,
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

Line 1204: from rcv_transactions_interface

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
1207: BEGIN
1208: /* Validate Location Information */