DBA Data[Home] [Help]

APPS.ZX_PTP_IMPORT dependencies on ORG_ORGANIZATION_DEFINITIONS

Line 4928: FROM org_organization_definitions ood,

4924: WHERE (( inventory_org_id IS NOT NULL
4925: AND NOT EXISTS
4926: (
4927: SELECT 1
4928: FROM org_organization_definitions ood,
4929: hr_all_organization_units org,
4930: hr_organization_information ori
4931: WHERE ood.organization_id = org.organization_id
4932: AND org.organization_id = ori.organization_id

Line 4949: FROM org_organization_definitions ood,

4945: AND inventory_org_name IS NOT NULL
4946: AND NOT EXISTS
4947: (
4948: SELECT 1
4949: FROM org_organization_definitions ood,
4950: hr_all_organization_units org,
4951: hr_organization_information ori
4952: WHERE ood.organization_id = org.organization_id
4953: AND org.organization_id = ORI.organization_id

Line 4978: FROM ORG_ORGANIZATION_DEFINITIONS OOD,

4974: UPDATE zx_exemptions_int exe_int
4975: SET Inventory_Org_id =
4976: (
4977: SELECT OOD.ORGANIZATION_ID
4978: FROM ORG_ORGANIZATION_DEFINITIONS OOD,
4979: HR_ALL_ORGANIZATION_UNITS ORG,
4980: HR_ORGANIZATION_INFORMATION ORI
4981: WHERE OOD.ORGANIZATION_ID = ORG.organization_id
4982: AND ORG.organization_id = ORI.organization_id