DBA Data[Home] [Help]

APPS.AHL_UC_INSTANCE_PVT dependencies on HR_ALL_ORGANIZATION_UNITS_TL

Line 6748: hr_all_organization_units_tl HAOUT

6744: FROM csi_item_instances CII,
6745: mtl_system_items_kfv MSIK,
6746: ahl_mc_relationships AMR,
6747: ahl_item_associations_b AIA,
6748: hr_all_organization_units_tl HAOUT
6749: WHERE CII.inventory_item_id = NVL(c_inventory_item_id, CII.inventory_item_id)
6750: AND MSIK.inventory_item_id = CII.inventory_item_id
6751: AND MSIK.organization_id = CII.inv_master_organization_id
6752: AND AMR.relationship_id = c_relationship_id

Line 6815: hr_all_organization_units_tl HAOUT

6811: trunc(nvl(CR.active_end_date (+), SYSDATE+1)) > trunc(SYSDATE)
6812: ) U,
6813: csi_item_instances CII,
6814: mtl_system_items_kfv MSIK,
6815: hr_all_organization_units_tl HAOUT
6816: WHERE CII.inventory_item_id = NVL(c_inventory_item_id, CII.inventory_item_id)
6817: AND U.csi_instance_id = CII.instance_id
6818: AND CII.inventory_item_id = MSIK.inventory_item_id
6819: AND CII.inv_master_organization_id = MSIK.organization_id