APPS.WMS_RULE_PVT dependencies on MTL_ONHAND_QUANTITIES_DETAIL

Line 683: mtl_onhand_quantities_detail moq

679: ,moq.lpn_id lpn_id
680: ,mils.project_id project_id
681: ,mils.task_id task_id
682: FROM
683: mtl_onhand_quantities_detail moq
684: , mtl_item_locations mils
685: WHERE
686: moq.organization_id = g_organization_id
687: AND moq.inventory_item_id = g_inventory_item_id

Line 698: from mtl_onhand_quantities_detail moq1

694: from wms_license_plate_numbers wlpn1
695: where wlpn1.parent_lpn_id = moq.lpn_id)
696: AND
697: 1 = (select count(distinct(moq1.inventory_item_id))
698: from mtl_onhand_quantities_detail moq1
699: where moq1.organization_id = moq.organization_id
700: and moq1.subinventory_code = moq.subinventory_code
701: and moq1.locator_id = moq.locator_id
702: and moq1.lpn_id = moq.lpn_id)

Line 764: mtl_onhand_quantities_detail moq,mtl_item_locations mils

760: ,moq.lpn_id lpn_id
761: ,decode(mils.project_id, mils.project_id, moq.project_id) project_id
762: ,decode(mils.task_id, mils.task_id, moq.task_id) task_id
763: FROM
764: mtl_onhand_quantities_detail moq,mtl_item_locations mils
765: WHERE
766: moq.organization_id = g_organization_id
767: AND moq.inventory_item_id = g_inventory_item_id
768: AND moq.organization_id = mils.organization_id (+)

Line 1576: from mtl_onhand_quantities_detail moq1

1572: from wms_license_plate_numbers wlpn1
1573: where wlpn1.parent_lpn_id = msn.lpn_id)
1574: and
1575: 1 = (select count(distinct(moq1.inventory_item_id))
1576: from mtl_onhand_quantities_detail moq1
1577: where moq1.organization_id = msn.current_organization_id
1578: and moq1.subinventory_code = msn.current_subinventory_code
1579: and moq1.locator_id = msn.current_locator_id
1580: and moq1.lpn_id = msn.lpn_id)

Line 1596: from mtl_onhand_quantities_detail moq1

1592: from wms_license_plate_numbers wlpn1
1593: where wlpn1.parent_lpn_id = msn.lpn_id)
1594: and
1595: 1 = (select count(distinct(moq1.inventory_item_id))
1596: from mtl_onhand_quantities_detail moq1
1597: where moq1.organization_id = msn.current_organization_id
1598: and moq1.subinventory_code = msn.current_subinventory_code
1599: and moq1.locator_id = msn.current_locator_id
1600: and moq1.lpn_id = msn.lpn_id)

Line 1613: from mtl_onhand_quantities_detail moq1

1609: from wms_license_plate_numbers wlpn1
1610: where wlpn1.parent_lpn_id = msn.lpn_id)
1611: and
1612: 1 = (select count(distinct(moq1.inventory_item_id))
1613: from mtl_onhand_quantities_detail moq1
1614: where moq1.organization_id = msn.current_organization_id
1615: and moq1.subinventory_code = msn.current_subinventory_code
1616: and moq1.locator_id = msn.current_locator_id
1617: and moq1.lpn_id = msn.lpn_id)

Line 4842: -- MTL_ONHAND_QUANTITIES_DETAIL and pending transactions from

4838: -- This procedure is used to get the quantity available to transact
4839: -- for a sub-transfer from a non-reservable subinventory.
4840: -- It assumed that pending transactions only exist at locator and lpn level
4841: -- The quantity is calculated with onhand quantity from
4842: -- MTL_ONHAND_QUANTITIES_DETAIL and pending transactions from
4843: -- MTL_MATERIAL_TRANSACTIONS_TEMP
4844: -- First get onhand and pending transactions at LPN level
4845: -- If LPN level availability > 0 then get pending transactions at Locator level
4846: -- return onhand less pending transactions

Line 4896: FROM mtl_onhand_quantities_detail moq

4892: IF p_lpn_id IS NOT NULL THEN
4893: -- LPN level
4894: SELECT SUM(moq.primary_transaction_quantity)
4895: INTO l_moq_qty
4896: FROM mtl_onhand_quantities_detail moq
4897: WHERE moq.organization_id = p_organization_id
4898: AND moq.inventory_item_id = p_inventory_item_id
4899: AND nvl(moq.revision,'@@') = nvl(p_revision,'@@')
4900: AND moq.subinventory_code = p_subinventory_code

Line 4986: FROM mtl_onhand_quantities_detail moq

4982: END IF;
4983:
4984: SELECT SUM(moq.primary_transaction_quantity)
4985: INTO l_moq_qty
4986: FROM mtl_onhand_quantities_detail moq
4987: WHERE moq.organization_id = p_organization_id
4988: AND moq.inventory_item_id = p_inventory_item_id
4989: AND nvl(moq.revision,'@@') = nvl(p_revision,'@@')
4990: AND moq.subinventory_code = p_subinventory_code

Line 6766: FROM mtl_onhand_quantities_detail

6762:
6763: --cursor to get the total quantity for the LPN
6764: CURSOR c_lpn_quantity IS
6765: SELECT SUM(primary_transaction_quantity)
6766: FROM mtl_onhand_quantities_detail
6767: WHERE lpn_id = v_current_row.lpn_id;
6768:
6769: --Bug 5251221, cursor to get the serials which are allocated for the current rule
6770: CURSOR l_get_serial IS

Line 15905: FROM mtl_onhand_quantities_detail

15901:
15902: --cursor to get the total quantity for the LPN
15903: CURSOR c_lpn_quantity IS
15904: SELECT SUM(primary_transaction_quantity)
15905: FROM mtl_onhand_quantities_detail
15906: WHERE lpn_id = v_current_row.lpn_id;
15907:
15908:
15909: BEGIN