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.

[Home] [Help]

APPS.ICX_REQ_SUBMIT dependencies on HR_LOCATIONS

Line 99: from hr_locations hrl,

95:
96:
97: cursor getLoccd(locid number) is
98: select hrl.location_code
99: from hr_locations hrl,
100: org_organization_definitions ood,
101: financials_system_parameters fsp
102: where hrl.location_id = locid
103: and ood.organization_id = nvl(hrl.inventory_organization_id,

Line 773: from hr_locations hrl,

769: cursor get_loc_org_id(loc varchar2) is
770: SELECT hrl.location_id,
771: nvl(hrl.inventory_organization_id,
772: fsp.inventory_organization_id) organization_id
773: from hr_locations hrl,
774: financials_system_parameters fsp
775: where sysdate < nvl(hrl.inactive_date, sysdate + 1)
776: and hrl.location_code = loc;
777:

Line 2042: from hr_locations hrl,

2038: set (DELIVER_TO_LOCATION_ID, DESTINATION_ORGANIZATION_ID) =
2039: (select hrl.location_id,
2040: nvl(hrl.inventory_organization_id,
2041: fsp.inventory_organization_id)
2042: from hr_locations hrl,
2043: financials_system_parameters fsp
2044: where sysdate < nvl(hrl.inactive_date, sysdate + 1)
2045: and hrl.location_code =
2046: icx_shopping_cart_lines.DELIVER_TO_LOCATION)