DBA Data[Home] [Help]

APPS.CSI_ORDER_SHIP_PUB dependencies on HR_ALL_ORGANIZATION_UNITS

Line 1787: hr_all_organization_units haou

1783: mtl_system_items msi,
1784: mtl_unit_transactions mut,
1785: mtl_material_transactions mmt,
1786: mtl_secondary_inventories msei,
1787: hr_all_organization_units haou
1788: WHERE mmt.transaction_id = p_trx_id
1789: AND mmt.transaction_id = mut.transaction_id(+)
1790: AND msi.organization_id = mmt.organization_id
1791: AND msi.inventory_item_id = mmt.inventory_item_id

Line 1848: hr_all_organization_units haou

1844: mtl_unit_transactions mut,
1845: mtl_transaction_lot_numbers mtln,
1846: mtl_material_transactions mmt,
1847: mtl_secondary_inventories msei,
1848: hr_all_organization_units haou
1849: WHERE mmt.transaction_id = p_trx_id
1850: AND mmt.transaction_id = mtln.transaction_id(+)
1851: AND mtln.serial_transaction_id = mut.transaction_id(+)
1852: AND msi.organization_id = mmt.organization_id