DBA Data[Home] [Help]

APPS.INV_QUANTITY_TREE_PVT dependencies on MTL_MATERIAL_STATUSES_B

Line 4772: , mtl_material_statuses_b mms -- Onhand Material Status Support

4768: ) x
4769: , mtl_secondary_inventories sub
4770: , mtl_item_locations loc
4771: , mtl_parameters mp -- Onhand Material Status Support
4772: , mtl_material_statuses_b mms -- Onhand Material Status Support
4773: WHERE
4774: x.organization_id = loc.organization_id (+)
4775: AND x.locator_id = loc.inventory_location_id (+)
4776: AND x.organization_id = sub.organization_id (+)

Line 6415: , mtl_material_statuses_b mms -- Onhand Material Status Support

6411: , mtl_secondary_inventories sub
6412: , mtl_item_locations loc
6413: , mtl_lot_numbers lot
6414: , mtl_parameters mp -- Onhand Material Status Support
6415: , mtl_material_statuses_b mms -- Onhand Material Status Support
6416: WHERE
6417: x.inventory_item_id = lot.inventory_item_id (+)
6418: AND x.organization_id = lot.organization_id (+)
6419: AND x.lot_number = lot.lot_number (+)

Line 7143: , mtl_material_statuses_b mms -- Onhand Material Status Support

7139: , mtl_secondary_inventories sub
7140: , mtl_item_locations loc
7141: , mtl_lot_numbers lot
7142: , mtl_parameters mp -- Onhand Material Status Support
7143: , mtl_material_statuses_b mms -- Onhand Material Status Support
7144: WHERE
7145: x.inventory_item_id = lot.inventory_item_id (+)
7146: AND x.organization_id = lot.organization_id (+)
7147: AND x.lot_number = lot.lot_number (+)