APPS.INV_QUANTITY_TREE_PVT dependencies on MTL_MATERIAL_STATUSES

Line 2511: FROM mtl_material_statuses mms

2507: SELECT '1'
2508: FROM mtl_secondary_inventories msinv
2509: WHERE msinv.status_id IN
2510: (SELECT mms.status_id
2511: FROM mtl_material_statuses mms
2512: WHERE NVL(mms.reservable_type, 1) = 1
2513: AND mms.zone_control = 1)
2514: AND msinv.organization_id = org_id
2515: AND msinv.secondary_inventory_name = subinv;

Line 2534: FROM mtl_material_statuses mms

2530: SELECT '1'
2531: FROM mtl_item_locations mil
2532: WHERE mil.status_id IN
2533: (SELECT mms.status_id
2534: FROM mtl_material_statuses mms
2535: WHERE NVL(mms.reservable_type, 1) = 1
2536: AND mms.locator_control = 1)
2537: AND mil.organization_id = org_id
2538: AND mil.inventory_location_id = loct_id;

Line 2560: FROM mtl_material_statuses mms

2556: SELECT '1'
2557: FROM mtl_lot_numbers mln
2558: WHERE mln.status_id IN
2559: (SELECT mms.status_id
2560: FROM mtl_material_statuses mms
2561: WHERE NVL(mms.reservable_type, 1) = 1
2562: AND mms.lot_control = 1)
2563: AND mln.inventory_item_id = item_id
2564: AND mln.organization_id = org_id

Line 2576: FROM mtl_onhand_quantities_detail moqd, mtl_material_statuses mms

2572: , loct_id IN NUMBER
2573: , lot IN VARCHAR2
2574: , lpn_id IN NUMBER) IS
2575: SELECT NVL(mms.reservable_type, 1)
2576: FROM mtl_onhand_quantities_detail moqd, mtl_material_statuses mms
2577: WHERE moqd.status_id = mms.status_id
2578: and moqd.status_id is not null
2579: AND moqd.inventory_item_id = item_id
2580: AND moqd.organization_id = org_id

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