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 1065: mtl_parameters org

1061: SELECT COUNT(*)
1062: INTO x_count
1063: FROM rcv_transactions_interface rti,
1064: hr_locations hl,
1065: mtl_parameters org
1066: -- BugFix 5219284, replaced org_organization_definitions with mtl_parameters for better performance.
1067: WHERE rti.header_interface_id = p_header_record.header_record.header_interface_id
1068: AND rti.to_organization_code IS NULL
1069: AND rti.to_organization_id IS NULL

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

1062: INTO x_count
1063: FROM rcv_transactions_interface rti,
1064: hr_locations hl,
1065: mtl_parameters org
1066: -- BugFix 5219284, replaced org_organization_definitions with mtl_parameters for better performance.
1067: WHERE rti.header_interface_id = p_header_record.header_record.header_interface_id
1068: AND rti.to_organization_code IS NULL
1069: AND rti.to_organization_id IS NULL
1070: AND rti.ship_to_location_id IS NOT NULL

Line 1091: mtl_parameters org

1087: SELECT COUNT(*)
1088: INTO x_count
1089: FROM rcv_transactions_interface rti,
1090: hr_locations hl,
1091: mtl_parameters org
1092: -- BugFix 5219284, replaced org_organization_definitions with mtl_parameters for better performance.
1093: WHERE rti.header_interface_id = p_header_record.header_record.header_interface_id
1094: AND rti.to_organization_code IS NULL
1095: AND rti.to_organization_id IS NULL

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

1088: INTO x_count
1089: FROM rcv_transactions_interface rti,
1090: hr_locations hl,
1091: mtl_parameters org
1092: -- BugFix 5219284, replaced org_organization_definitions with mtl_parameters for better performance.
1093: WHERE rti.header_interface_id = p_header_record.header_record.header_interface_id
1094: AND rti.to_organization_code IS NULL
1095: AND rti.to_organization_id IS NULL
1096: AND rti.ship_to_location_code IS NOT NULL