DBA Data[Home] [Help]

APPS.INV_QUANTITY_TREE_PVT dependencies on MTL_MATERIAL_STATUSES_B

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

5545: ) x
5546: , mtl_secondary_inventories sub
5547: , mtl_item_locations loc -- invConv change
5548: , mtl_parameters mp -- Onhand Material Status Support
5549: , mtl_material_statuses_b mms -- Onhand Material Status Support
5550: WHERE
5551: x.organization_id = loc.organization_id (+) -- invConv change
5552: AND x.locator_id = loc.inventory_location_id (+) -- invConv change
5553: AND x.organization_id = sub.organization_id (+)

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

6206: , mtl_secondary_inventories sub
6207: , mtl_item_locations loc -- invConv change
6208: , mtl_lot_numbers lot
6209: , mtl_parameters mp -- Onhand Material Status Support
6210: , mtl_material_statuses_b mms -- Onhand Material Status Support
6211: WHERE
6212: x.inventory_item_id = lot.inventory_item_id (+) -- invConv change
6213: AND x.organization_id = lot.organization_id (+) -- invConv change
6214: AND x.lot_number = lot.lot_number (+) -- invConv change

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

6861: , mtl_secondary_inventories sub
6862: , mtl_item_locations loc -- invConv change
6863: , mtl_lot_numbers lot
6864: , mtl_parameters mp -- Onhand Material Status Support
6865: , mtl_material_statuses_b mms -- Onhand Material Status Support
6866: WHERE
6867: x.inventory_item_id = lot.inventory_item_id (+) -- invConv change
6868: AND x.organization_id = lot.organization_id (+) -- invConv change
6869: AND x.lot_number = lot.lot_number (+) -- invConv change