DBA Data[Home] [Help]

APPS.CSI_INV_TRXS_PKG dependencies on MTL_PHYSICAL_INVENTORIES

Line 117: mtl_physical_inventories mpi,

113: SELECT mpi.physical_inventory_id physical_inventory_id,
114: mpi.physical_inventory_name physical_inventory_name,
115: mpit.tag_number tag_number
116: FROM mtl_physical_adjustments mpa,
117: mtl_physical_inventories mpi,
118: mtl_physical_inventory_tags mpit
119: WHERE mpa.physical_inventory_id = mpi.physical_inventory_id
120: AND mpa.physical_inventory_id = mpit.physical_inventory_id
121: AND mpa.adjustment_id = mpit.adjustment_id

Line 2197: mtl_physical_inventories mpi,

2193: SELECT mpi.physical_inventory_id physical_inventory_id,
2194: mpi.physical_inventory_name physical_inventory_name,
2195: mpit.tag_number tag_number
2196: FROM mtl_physical_adjustments mpa,
2197: mtl_physical_inventories mpi,
2198: mtl_physical_inventory_tags mpit
2199: WHERE mpa.physical_inventory_id = mpi.physical_inventory_id
2200: AND mpa.physical_inventory_id = mpit.physical_inventory_id
2201: AND mpa.adjustment_id = mpit.adjustment_id