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_HEADERS_INTERFACE_SV dependencies on MTL_PARAMETERS

Line 869: mtl_parameters org --Replaced org_organization_definitions

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
872: AND rti.to_organization_id IS NULL
873: AND rti.ship_to_location_id IS NOT NULL

Line 894: mtl_parameters org --Replaced org_organization_definitions

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
897: AND rti.to_organization_id IS NULL
898: AND rti.ship_to_location_code IS NOT NULL

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

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

Line 1571: mtl_parameters mtl

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

Line 1582: * new one where we select the organization_code from table MTL_PARAMETERS

1578: asn_debug.put_line('Trying to retrieve from ship to location');
1579: END IF;
1580:
1581: /* Bug# 3924530 FP from 11i9 fix. Replaced the sql statement below with a
1582: * new one where we select the organization_code from table MTL_PARAMETERS
1583: * instead of the expensive nonmergible view ORG_ORGANIZATION_DEFINITIONS.
1584:
1585: SELECT MAX(org.organization_code)
1586: INTO x_to_organization_code

Line 1599: MTL_PARAMETERS MTL

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
1602: OR RTI.SHIP_TO_LOCATION_ID = HL.LOCATION_ID)
1603: AND HL.INVENTORY_ORGANIZATION_ID = MTL.ORGANIZATION_ID;