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 2251: mtl_physical_inventories mpi,

2247: SELECT mpi.physical_inventory_id physical_inventory_id,
2248: mpi.physical_inventory_name physical_inventory_name,
2249: mpit.tag_number tag_number
2250: FROM mtl_physical_adjustments mpa,
2251: mtl_physical_inventories mpi,
2252: mtl_physical_inventory_tags mpit
2253: WHERE mpa.physical_inventory_id = mpi.physical_inventory_id
2254: AND mpa.physical_inventory_id = mpit.physical_inventory_id
2255: AND mpa.adjustment_id = mpit.adjustment_id