eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.INV_CONSIGNED_VALIDATIONS dependencies on MTL_ONHAND_QUANTITIES_DETAIL

Line 464: mtl_onhand_quantities_detail moq

460: 1, 1, 0) containerized
461: , moq.planning_organization_id planning_organization_id
462: , moq.owning_organization_id owning_organization_id
463: FROM
464: mtl_onhand_quantities_detail moq
465: WHERE moq.organization_id <> Nvl(moq.planning_organization_id,moq.organization_id)
466: OR moq.organization_id <> nvl(moq.owning_organization_id, moq.organization_id) ';
467:
468: -- dealing with pending transactions in mmtt

Line 1587: FROM mtl_onhand_quantities_detail

1583: SELECT Nvl(sum(primary_transaction_quantity),0)
1584: , Nvl(sum(secondary_transaction_quantity),0)
1585: INTO x_att
1586: , x_satt
1587: FROM mtl_onhand_quantities_detail
1588: WHERE owning_organization_id = organization_id
1589: AND organization_id = p_organization_id
1590: AND owning_organization_id <> p_owning_org_id
1591: AND inventory_item_id = p_inventory_item_id

Line 2106: -- MTL_ONHAND_QUANTITIES_DETAIL and pending transactions from

2102: -- This API returns the onhand quantity for planning purpose
2103: -- When it is called for Subinventory level query, it includes VMI quantity, because replenishment within the warehouse should not distinguish VMI stocks
2104: -- When it is called for Organization level query, it does not include VMI quantity, because relenishment for the whole warehouse should affect VMI stock
2105: -- The quantity is calculated with onhand quantity from
2106: -- MTL_ONHAND_QUANTITIES_DETAIL and pending transactions from
2107: -- MTL_MATERIAL_TRANSACTIONS_TEMP
2108: -- The quantities does not include suggestions
2109: -- Input Parameters
2110: -- P_INCLUDE_NONNET: Whether include non-nettable subinventories

Line 2260: FROM mtl_onhand_quantities_detail moq, mtl_lot_numbers mln, mtl_secondary_inventories msi

2256: SELECT SUM(moq.primary_transaction_quantity)
2257: , SUM( NVL(moq.secondary_transaction_quantity, 0))
2258: INTO l_moq_qty
2259: , l_moq_sqty
2260: FROM mtl_onhand_quantities_detail moq, mtl_lot_numbers mln, mtl_secondary_inventories msi
2261: WHERE moq.organization_id = p_org_id
2262: AND moq.inventory_item_id = p_item_id
2263: AND msi.organization_id = moq.organization_id
2264: AND msi.secondary_inventory_name = moq.subinventory_code

Line 2755: FROM mtl_onhand_quantities_detail moq, mtl_lot_numbers mln

2751: SELECT SUM(moq.primary_transaction_quantity)
2752: , SUM( NVL(moq.secondary_transaction_quantity, 0))
2753: INTO l_moq_qty
2754: , l_moq_sqty
2755: FROM mtl_onhand_quantities_detail moq, mtl_lot_numbers mln
2756: WHERE moq.organization_id = p_org_id
2757: AND moq.inventory_item_id = p_item_id
2758: AND moq.subinventory_code = p_subinv
2759: AND moq.lot_number = mln.lot_number(+)

Line 2898: -- MTL_ONHAND_QUANTITIES_DETAIL and pending transactions from

2894: -- Bug 4247148: Added a new function to get the onhand qty
2895: -- This API returns the onhand quantity for planning purpose based on ATPable/Nettable/All subs
2896: -- When it is called for Organization level query, it does not include VMI quantity, because relenishment for the whole warehouse should affect VMI stock
2897: -- The quantity is calculated with onhand quantity from
2898: -- MTL_ONHAND_QUANTITIES_DETAIL and pending transactions from
2899: -- MTL_MATERIAL_TRANSACTIONS_TEMP
2900: -- The quantities does not include suggestions
2901: -- Input Parameters
2902: -- P_ONHAND_SOURCE: Whether include atpable/non-nettable subinventories

Line 2962: FROM mtl_onhand_quantities_detail moq, mtl_lot_numbers mln

2958:
2959: IF (p_onhand_source = g_atpable_only) THEN
2960: SELECT SUM(moq.primary_transaction_quantity)
2961: INTO l_moq_qty
2962: FROM mtl_onhand_quantities_detail moq, mtl_lot_numbers mln
2963: WHERE moq.organization_id = p_org_id
2964: AND moq.inventory_item_id = p_item_id
2965: AND EXISTS (select 'x' from mtl_secondary_inventories msi
2966: WHERE msi.organization_id = moq.organization_id and

Line 2978: FROM mtl_onhand_quantities_detail moq, mtl_lot_numbers mln

2974: AND nvl(moq.planning_tp_type,2) = 2;
2975: ELSE
2976: SELECT SUM(moq.primary_transaction_quantity)
2977: INTO l_moq_qty
2978: FROM mtl_onhand_quantities_detail moq, mtl_lot_numbers mln
2979: WHERE moq.organization_id = p_org_id
2980: AND moq.inventory_item_id = p_item_id
2981: AND EXISTS
2982: (select 'x' from mtl_secondary_inventories msi

Line 3224: FROM mtl_onhand_quantities_detail moq, mtl_lot_numbers mln

3220:
3221: IF (p_onhand_source = g_atpable_only) THEN
3222: SELECT SUM(moq.primary_transaction_quantity)
3223: INTO l_moq_qty
3224: FROM mtl_onhand_quantities_detail moq, mtl_lot_numbers mln
3225: WHERE moq.organization_id = p_org_id
3226: AND moq.inventory_item_id = p_item_id
3227: AND EXISTS (select 'x' from mtl_secondary_inventories msi
3228: WHERE msi.organization_id = moq.organization_id and

Line 3249: FROM mtl_onhand_quantities_detail moq, mtl_lot_numbers mln

3245: );
3246: ELSE
3247: SELECT SUM(moq.primary_transaction_quantity)
3248: INTO l_moq_qty
3249: FROM mtl_onhand_quantities_detail moq, mtl_lot_numbers mln
3250: WHERE moq.organization_id = p_org_id
3251: AND moq.inventory_item_id = p_item_id
3252: AND EXISTS
3253: (select 'x' from mtl_secondary_inventories msi

Line 3687: mtl_onhand_quantities_detail moq

3683: , moq.planning_organization_id planning_organization_id
3684: , moq.owning_organization_id owning_organization_id
3685: , moq.lpn_id lpn_id
3686: FROM
3687: mtl_onhand_quantities_detail moq
3688: WHERE moq.organization_id <> Nvl(moq.planning_organization_id,moq.organization_id)
3689: OR moq.organization_id <> nvl(moq.owning_organization_id, moq.organization_id) ';
3690:
3691: -- common restrictions

Line 4215: FROM mtl_onhand_quantities_detail

4211: IF (l_debug = 1) THEN
4212: inv_log_util.trace('Transfer regular to consigned','CONSIGNED_VALIDATIONS',9);
4213: END IF;
4214: SELECT Nvl(sum(primary_transaction_quantity),0) INTO x_att
4215: FROM mtl_onhand_quantities_detail
4216: WHERE owning_organization_id = organization_id
4217: AND organization_id = p_organization_id
4218: AND owning_organization_id <> p_owning_org_id
4219: AND inventory_item_id = p_inventory_item_id