DBA Data[Home] [Help]

APPS.ICX_REQ_ORDER dependencies on ORG_ORGANIZATION_DEFINITIONS

Line 1162: org_organization_definitions ood,

1158:
1159: cursor location(v_location_id number) is
1160: select hrl.location_code
1161: from hr_locations hrl,
1162: org_organization_definitions ood,
1163: financials_system_parameters fsp
1164: where hrl.location_id = v_location_id
1165: and ood.organization_id = nvl(hrl.inventory_organization_id,
1166: fsp.inventory_organization_id)

Line 2636: org_organization_definitions ood

2632: select gsob.CURRENCY_CODE,
2633: fc.PRECISION
2634: from gl_sets_of_books gsob,
2635: FND_CURRENCIES fc,
2636: org_organization_definitions ood
2637: where ood.ORGANIZATION_ID = v_org
2638: and fc.CURRENCY_CODE = gsob.CURRENCY_CODE
2639: and ood.SET_OF_BOOKS_ID = gsob.SET_OF_BOOKS_ID;
2640:

Line 2676: org_organization_definitions ood,

2672: ood.organization_id,
2673: ood.organization_code
2674: from hr_locations hrl,
2675: hr_employees_current_v hrev,
2676: org_organization_definitions ood,
2677: financials_system_parameters fsp
2678: where hrev.employee_id = v_shop_id
2679: and hrev.location_id = hrl.location_id
2680: and ood.organization_id = nvl(hrl.inventory_organization_id,