APPS.RCV_ROI_HEADER_COMMON dependencies on MTL_PARAMETERS

Line 273: /* ksareddy RVCTP performance fix 2481798 - select from mtl_parameters instead

269: asn_debug.put_line('No ship to org specified at the lines either');
270: asn_debug.put_line('Trying to retrieve from to_organization_id');
271: END IF;
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

Line 284: mtl_parameters mtl

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;
288:

Line 298: mtl_parameters org

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
301: AND ( rti.ship_to_location_code = hl.location_code
302: OR rti.ship_to_location_id = hl.location_id)

Line 299: -- BugFix 5219284, replaced org_organization_definitions with mtl_parameters for better performance.

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
301: AND ( rti.ship_to_location_code = hl.location_code
302: OR rti.ship_to_location_id = hl.location_id)
303: AND hl.inventory_organization_id = org.organization_id;

Line 1008: mtl_parameters org

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
1011: AND rti.to_organization_code IS NULL
1012: AND rti.to_organization_id IS NULL

Line 1009: -- BugFix 5219284, replaced org_organization_definitions with mtl_parameters for better performance.

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
1011: AND rti.to_organization_code IS NULL
1012: AND rti.to_organization_id IS NULL
1013: AND rti.ship_to_location_id IS NOT NULL

Line 1034: mtl_parameters org

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
1037: AND rti.to_organization_code IS NULL
1038: AND rti.to_organization_id IS NULL

Line 1035: -- BugFix 5219284, replaced org_organization_definitions with mtl_parameters for better performance.

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
1037: AND rti.to_organization_code IS NULL
1038: AND rti.to_organization_id IS NULL
1039: AND rti.ship_to_location_code IS NOT NULL