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.WMS_RULE_PVT dependencies on MTL_ONHAND_QUANTITIES_DETAIL

Line 703: mtl_onhand_quantities_detail moq

699: ,moq.lpn_id lpn_id
700: ,mils.project_id project_id
701: ,mils.task_id task_id
702: FROM
703: mtl_onhand_quantities_detail moq
704: , mtl_item_locations mils
705: WHERE
706: moq.organization_id = g_organization_id
707: AND moq.inventory_item_id = g_inventory_item_id

Line 718: from mtl_onhand_quantities_detail moq1

714: from wms_license_plate_numbers wlpn1
715: where wlpn1.parent_lpn_id = moq.lpn_id)
716: AND
717: 1 = (select count(distinct(moq1.inventory_item_id))
718: from mtl_onhand_quantities_detail moq1
719: where moq1.organization_id = moq.organization_id
720: and moq1.subinventory_code = moq.subinventory_code
721: and moq1.locator_id = moq.locator_id
722: and moq1.lpn_id = moq.lpn_id)

Line 789: mtl_onhand_quantities_detail moq,mtl_item_locations mils

785: ,moq.lpn_id lpn_id
786: ,decode(mils.project_id, mils.project_id, moq.project_id) project_id
787: ,decode(mils.task_id, mils.task_id, moq.task_id) task_id
788: FROM
789: mtl_onhand_quantities_detail moq,mtl_item_locations mils
790: WHERE
791: moq.organization_id = g_organization_id
792: AND moq.inventory_item_id = g_inventory_item_id
793: AND moq.organization_id = mils.organization_id (+)

Line 1659: from mtl_onhand_quantities_detail moq1

1655: from wms_license_plate_numbers wlpn1
1656: where wlpn1.parent_lpn_id = msn.lpn_id)
1657: and
1658: 1 = (select count(distinct(moq1.inventory_item_id))
1659: from mtl_onhand_quantities_detail moq1
1660: where moq1.organization_id = msn.current_organization_id
1661: and moq1.subinventory_code = msn.current_subinventory_code
1662: and moq1.locator_id = msn.current_locator_id
1663: and moq1.lpn_id = msn.lpn_id)

Line 1679: from mtl_onhand_quantities_detail moq1

1675: from wms_license_plate_numbers wlpn1
1676: where wlpn1.parent_lpn_id = msn.lpn_id)
1677: and
1678: 1 = (select count(distinct(moq1.inventory_item_id))
1679: from mtl_onhand_quantities_detail moq1
1680: where moq1.organization_id = msn.current_organization_id
1681: and moq1.subinventory_code = msn.current_subinventory_code
1682: and moq1.locator_id = msn.current_locator_id
1683: and moq1.lpn_id = msn.lpn_id)

Line 1696: from mtl_onhand_quantities_detail moq1

1692: from wms_license_plate_numbers wlpn1
1693: where wlpn1.parent_lpn_id = msn.lpn_id)
1694: and
1695: 1 = (select count(distinct(moq1.inventory_item_id))
1696: from mtl_onhand_quantities_detail moq1
1697: where moq1.organization_id = msn.current_organization_id
1698: and moq1.subinventory_code = msn.current_subinventory_code
1699: and moq1.locator_id = msn.current_locator_id
1700: and moq1.lpn_id = msn.lpn_id)

Line 6573: -- MTL_ONHAND_QUANTITIES_DETAIL and pending transactions from

6569: -- This procedure is used to get the quantity available to transact
6570: -- for a sub-transfer from a non-reservable subinventory.
6571: -- It assumed that pending transactions only exist at locator and lpn level
6572: -- The quantity is calculated with onhand quantity from
6573: -- MTL_ONHAND_QUANTITIES_DETAIL and pending transactions from
6574: -- MTL_MATERIAL_TRANSACTIONS_TEMP
6575: -- First get onhand and pending transactions at LPN level
6576: -- If LPN level availability > 0 then get pending transactions at Locator level
6577: -- return onhand less pending transactions

Line 6627: FROM mtl_onhand_quantities_detail moq

6623: IF p_lpn_id IS NOT NULL THEN
6624: -- LPN level
6625: SELECT SUM(moq.primary_transaction_quantity)
6626: INTO l_moq_qty
6627: FROM mtl_onhand_quantities_detail moq
6628: WHERE moq.organization_id = p_organization_id
6629: AND moq.inventory_item_id = p_inventory_item_id
6630: AND nvl(moq.revision,'@@') = nvl(p_revision,'@@')
6631: AND moq.subinventory_code = p_subinventory_code

Line 6717: FROM mtl_onhand_quantities_detail moq

6713: END IF;
6714:
6715: SELECT SUM(moq.primary_transaction_quantity)
6716: INTO l_moq_qty
6717: FROM mtl_onhand_quantities_detail moq
6718: WHERE moq.organization_id = p_organization_id
6719: AND moq.inventory_item_id = p_inventory_item_id
6720: AND nvl(moq.revision,'@@') = nvl(p_revision,'@@')
6721: AND moq.subinventory_code = p_subinventory_code

Line 8705: FROM mtl_onhand_quantities_detail

8701: --cursor to get the total quantity for the LPN
8702: CURSOR c_lpn_quantity IS
8703: SELECT SUM(primary_transaction_quantity)
8704: , NVL(SUM(secondary_transaction_quantity),0)
8705: FROM mtl_onhand_quantities_detail
8706: WHERE lpn_id = v_current_row.lpn_id;
8707:
8708: --Bug 5251221, cursor to get the serials which are allocated for the current rule
8709: CURSOR l_get_serial IS

Line 18545: FROM mtl_onhand_quantities_detail

18541:
18542: --cursor to get the total quantity for the LPN
18543: CURSOR c_lpn_quantity IS
18544: SELECT SUM(primary_transaction_quantity)
18545: FROM mtl_onhand_quantities_detail
18546: WHERE lpn_id = v_current_row.lpn_id;
18547:
18548:
18549: BEGIN