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_QUANTITY_TREE_PVT dependencies on MTL_ONHAND_QUANTITIES_DETAIL

Line 879: FROM mtl_onhand_quantities_detail moqd, mtl_material_statuses mms

875:
876: BEGIN
877:
878: SELECT NVL(mms.reservable_type, 1) INTO l_reservable_type
879: FROM mtl_onhand_quantities_detail moqd, mtl_material_statuses mms
880: WHERE moqd.status_id = mms.status_id
881: AND moqd.status_id is not null
882: AND moqd.inventory_item_id = p_inventory_item_id
883: AND moqd.organization_id = p_organization_id

Line 1051: FROM mtl_onhand_quantities_detail moqd, mtl_material_statuses mms

1047: , loct_id IN NUMBER
1048: , lot IN VARCHAR2
1049: , p_lpn_id IN NUMBER) IS
1050: SELECT NVL(mms.reservable_type, 1)
1051: FROM mtl_onhand_quantities_detail moqd, mtl_material_statuses mms
1052: WHERE moqd.status_id = mms.status_id
1053: and moqd.status_id is not null
1054: AND moqd.inventory_item_id = item_id
1055: AND moqd.organization_id = org_id

Line 4418: mtl_onhand_quantities_detail moq

4414: , to_number(NULL) transaction_action_id
4415: , to_char(NULL) transfer_subinventory_code
4416: , to_number(NULL) transfer_locator_id
4417: FROM
4418: mtl_onhand_quantities_detail moq
4419:
4420: UNION ALL
4421: -- pending transactions in mmtt
4422: SELECT

Line 4639: mtl_onhand_quantities_detail moq

4635: , to_char(NULL) transfer_subinventory_code
4636: , to_number(NULL) transfer_locator_id
4637: , moq.status_id -- Onhand Material Status Support
4638: FROM
4639: mtl_onhand_quantities_detail moq
4640: UNION ALL
4641: -- pending transactions in mmtt
4642: SELECT
4643: mmtt.organization_id organization_id

Line 4931: mtl_onhand_quantities_detail moq

4927: , to_number(NULL) transaction_action_id
4928: , to_char(NULL) transfer_subinventory_code
4929: , to_number(NULL) transfer_locator_id
4930: FROM
4931: mtl_onhand_quantities_detail moq
4932: UNION ALL
4933: -- pending transactions in mmtt, lot in MMTT
4934: SELECT
4935: mmtt.organization_id organization_id

Line 5299: mtl_onhand_quantities_detail moq

5295: , to_number(NULL) transaction_action_id
5296: , to_char(NULL) transfer_subinventory_code
5297: , to_number(NULL) transfer_locator_id
5298: FROM
5299: mtl_onhand_quantities_detail moq
5300: GROUP BY moq.organization_id,moq.inventory_item_id,moq.revision,
5301: moq.subinventory_code,moq.locator_id,moq.lot_number,
5302: moq.lpn_id,moq.cost_group_id
5303: UNION ALL

Line 5801: mtl_onhand_quantities_detail moq

5797: , to_number(NULL) transaction_action_id
5798: , to_char(NULL) transfer_subinventory_code
5799: , to_number(NULL) transfer_locator_id
5800: FROM
5801: mtl_onhand_quantities_detail moq
5802: UNION ALL
5803: -- pending transactions in mmtt, lot in MMTT
5804: SELECT
5805: mmtt.organization_id organization_id

Line 6120: mtl_onhand_quantities_detail moq

6116: , to_char(NULL) transfer_subinventory_code
6117: , to_number(NULL) transfer_locator_id
6118: , moq.status_id -- Onhand Material Status Support
6119: FROM
6120: mtl_onhand_quantities_detail moq
6121: UNION ALL
6122: -- pending transactions in mmtt, lot in MMTT
6123: SELECT
6124: mmtt.organization_id organization_id

Line 6571: mtl_onhand_quantities_detail moq

6567: , to_number(NULL) transaction_action_id
6568: , to_char(NULL) transfer_subinventory_code
6569: , to_number(NULL) transfer_locator_id
6570: FROM
6571: mtl_onhand_quantities_detail moq
6572: UNION ALL
6573: -- pending transactions in mmtt, lot in MMTT
6574: SELECT
6575: mmtt.organization_id organization_id

Line 6890: mtl_onhand_quantities_detail moq

6886: , to_char(NULL) transfer_subinventory_code
6887: , to_number(NULL) transfer_locator_id
6888: , moq.status_id -- Onhand Material Status Support
6889: FROM
6890: mtl_onhand_quantities_detail moq
6891: UNION ALL
6892: -- pending transactions in mmtt, lot in MMTT
6893: SELECT
6894: mmtt.organization_id organization_id

Line 7320: mtl_onhand_quantities_detail moq

7316: , to_number(NULL) transaction_action_id
7317: , to_char(NULL) transfer_subinventory_code
7318: , to_number(NULL) transfer_locator_id
7319: FROM
7320: mtl_onhand_quantities_detail moq
7321: GROUP BY moq.organization_id,moq.inventory_item_id,moq.revision,
7322: moq.subinventory_code,moq.locator_id,moq.lot_number,
7323: moq.lpn_id,moq.cost_group_id
7324: UNION ALL

Line 7623: mtl_onhand_quantities_detail moq

7619: , to_number(NULL) transaction_action_id
7620: , to_char(NULL) transfer_subinventory_code
7621: , to_number(NULL) transfer_locator_id
7622: FROM
7623: mtl_onhand_quantities_detail moq
7624: GROUP BY moq.organization_id,moq.inventory_item_id,moq.revision,
7625: moq.subinventory_code,moq.locator_id,moq.lot_number,
7626: moq.lpn_id,moq.cost_group_id
7627: UNION ALL

Line 8079: mtl_onhand_quantities_detail moq

8075: , to_number(NULL) transaction_action_id
8076: , to_char(NULL) transfer_subinventory_code
8077: , to_number(NULL) transfer_locator_id
8078: FROM
8079: mtl_onhand_quantities_detail moq
8080: GROUP BY moq.organization_id,moq.inventory_item_id,moq.revision,
8081: moq.subinventory_code,moq.locator_id,moq.lot_number,
8082: moq.lpn_id,moq.cost_group_id
8083: UNION ALL