DBA Data[Home] [Help]

APPS.ENGPKIMP dependencies on HR_ALL_ORGANIZATION_UNITS_TL

Line 1617: -- added joint tables mtl_parameters, hr_all_organization_units_tl

1613: -- odab added columns change_id, organization_code
1614: -- , organization_name, concatenated_segments, description
1615: -- last_update_date, last_updated_by, creation_date, created_by
1616: -- replaced mtl_system_items by mtl_system_items_vl
1617: -- added joint tables mtl_parameters, hr_all_organization_units_tl
1618: Cursor get_item_info is
1619: Select i.change_notice,
1620: i.change_id, -- ERES change
1621: i.organization_id,

Line 1680: hr_all_organization_units_tl hou -- ERES change

1676: i.from_end_item_rev_id
1677: from eng_revised_items i,
1678: mtl_system_items_vl si, -- ERES change
1679: mtl_parameters mp1, -- ERES change
1680: hr_all_organization_units_tl hou -- ERES change
1681: where i.revised_item_sequence_id = revised_item
1682: and si.inventory_item_id = i.revised_item_id
1683: and si.organization_id = i.organization_id
1684: AND hou.organization_id = i.organization_id