APPS.RCV_HEADERS_INTERFACE_SV dependencies on RCV_TRANSACTIONS_INTERFACE

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

65: /* organization_id is uk. org_organization_definitions is a view */
66: IF p_header_record.error_record.error_status IN('S', 'W') THEN
67: /*
68: ** If the shipment header ship to organization code is null then try
69: ** to pull it off the rcv_transactions_interface to_organization_code or
70: ** the ship_to_location_code.
71: */
72: IF ( p_header_record.header_record.ship_to_organization_code IS NULL
73: AND p_header_record.header_record.ship_to_organization_id IS NULL) THEN

Line 378: FROM rcv_transactions_interface rti

374: IF p_header_record.header_record.receipt_num IS NULL
375: AND p_header_record.header_record.transaction_type <> 'CANCEL' THEN -- added for support of cancel
376: SELECT COUNT(*)
377: INTO v_count
378: FROM rcv_transactions_interface rti
379: WHERE rti.header_interface_id = p_header_record.header_record.header_interface_id
380: AND ( rti.auto_transact_code IN('RECEIVE', 'DELIVER')
381: OR rti.transaction_type IN('RECEIVE', 'DELIVER'));
382:

Line 485: FROM rcv_transactions_interface rti

481: SELECT MAX(rti.po_header_id),
482: MAX(document_num)
483: INTO x_po_header_id,
484: x_document_num
485: FROM rcv_transactions_interface rti
486: WHERE rti.header_interface_id = p_header_record.header_record.header_interface_id;
487:
488: IF ( x_po_header_id IS NULL
489: AND x_document_num IS NOT NULL) THEN

Line 834: FROM rcv_transactions_interface rti,

830: END IF;
831:
832: SELECT COUNT(*)
833: INTO x_count
834: FROM rcv_transactions_interface rti,
835: rcv_headers_interface rhi
836: WHERE rti.header_interface_id = p_header_record.header_record.header_interface_id
837: AND rhi.header_interface_id = rti.header_interface_id
838: AND ( ( rti.to_organization_code IS NOT NULL

Line 867: FROM rcv_transactions_interface rti,

863: during the line level organization derivation.
864: */
865: SELECT COUNT(*)
866: INTO x_count
867: FROM rcv_transactions_interface rti,
868: hr_locations_all hl, --Bug 5219141. Replace hr_locations by hr_locations_all
869: mtl_parameters org --Replaced org_organization_definitions
870: WHERE rti.header_interface_id = p_header_record.header_record.header_interface_id
871: AND rti.to_organization_code IS NULL

Line 892: FROM rcv_transactions_interface rti,

888: */
889: IF x_count = 0 THEN
890: SELECT COUNT(*)
891: INTO x_count
892: FROM rcv_transactions_interface rti,
893: hr_locations_all hl, --Bug 5219141. Replace hr_locations by hr_locations_all
894: mtl_parameters org --Replaced org_organization_definitions
895: WHERE rti.header_interface_id = p_header_record.header_record.header_interface_id
896: AND rti.to_organization_code IS NULL

Line 1547: FROM rcv_transactions_interface rti

1543: END IF;
1544:
1545: SELECT MAX(rti.to_organization_code)
1546: INTO x_to_organization_code
1547: FROM rcv_transactions_interface rti
1548: WHERE rti.header_interface_id = x_header_interface_id;
1549:
1550: /* Bug# 1465730 - If Ship To Organization Code is not specified at lines
1551: * then derive it from the To Organization Id and if this is also not

Line 1563: FROM RCV_TRANSACTIONS_INTERFACE RTI,

1559:
1560: /* ksareddy RVCTP performance fix 2481798 - select from mtl_parameters instead
1561: SELECT MAX(ORG.ORGANIZATION_CODE)
1562: INTO X_TO_ORGANIZATION_CODE
1563: FROM RCV_TRANSACTIONS_INTERFACE RTI,
1564: ORG_ORGANIZATION_DEFINITIONS ORG
1565: WHERE RTI.HEADER_INTERFACE_ID = X_HEADER_INTERFACE_ID
1566: AND ORG.ORGANIZATION_ID = RTI.TO_ORGANIZATION_ID;
1567: */

Line 1570: FROM rcv_transactions_interface rti,

1566: AND ORG.ORGANIZATION_ID = RTI.TO_ORGANIZATION_ID;
1567: */
1568: SELECT MAX(mtl.organization_code)
1569: INTO x_to_organization_code
1570: FROM rcv_transactions_interface rti,
1571: mtl_parameters mtl
1572: WHERE rti.header_interface_id = x_header_interface_id
1573: AND mtl.organization_id = rti.to_organization_id;
1574: END IF;

Line 1587: FROM rcv_transactions_interface rti,

1583: * instead of the expensive nonmergible view ORG_ORGANIZATION_DEFINITIONS.
1584:
1585: SELECT MAX(org.organization_code)
1586: INTO x_to_organization_code
1587: FROM rcv_transactions_interface rti,
1588: hr_locations hl,
1589: org_organization_definitions org
1590: WHERE rti.header_interface_id = x_header_interface_id
1591: AND ( rti.ship_to_location_code = hl.location_code

Line 1597: FROM RCV_TRANSACTIONS_INTERFACE RTI,

1593: AND hl.inventory_organization_id = org.organization_id;*/
1594:
1595: SELECT MAX(MTL.ORGANIZATION_CODE)
1596: INTO X_TO_ORGANIZATION_CODE
1597: FROM RCV_TRANSACTIONS_INTERFACE RTI,
1598: HR_LOCATIONS_ALL HL, --BUG 5219141 Replaced HR_LOCATIONS
1599: MTL_PARAMETERS MTL
1600: WHERE RTI.HEADER_INTERFACE_ID = X_HEADER_INTERFACE_ID
1601: AND (RTI.SHIP_TO_LOCATION_CODE = HL.LOCATION_CODE