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 566: mtl_onhand_quantities_detail moq ';

562: , to_number(NULL) transaction_action_id
563: , to_char(NULL) transfer_subinventory_code
564: , to_number(NULL) transfer_locator_id
565: FROM
566: mtl_onhand_quantities_detail moq ';
567:
568:
569: -- dealing with pending transactions in mmtt
570: -- and picking suggestions

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 5235: mtl_onhand_quantities_detail moq

5231: , to_number(NULL) transaction_action_id
5232: , to_char(NULL) transfer_subinventory_code
5233: , to_number(NULL) transfer_locator_id
5234: FROM
5235: mtl_onhand_quantities_detail moq
5236:
5237: UNION ALL
5238: -- pending transactions in mmtt
5239: SELECT

Line 5435: mtl_onhand_quantities_detail moq

5431: , to_char(NULL) transfer_subinventory_code
5432: , to_number(NULL) transfer_locator_id
5433: , moq.status_id -- Onhand Material Status Support
5434: FROM
5435: mtl_onhand_quantities_detail moq
5436: UNION ALL
5437: -- pending transactions in mmtt
5438: SELECT
5439: mmtt.organization_id organization_id

Line 5712: mtl_onhand_quantities_detail moq

5708: , to_number(NULL) transaction_action_id
5709: , to_char(NULL) transfer_subinventory_code
5710: , to_number(NULL) transfer_locator_id
5711: FROM
5712: mtl_onhand_quantities_detail moq
5713: UNION ALL
5714: -- pending transactions in mmtt, lot in MMTT
5715: SELECT
5716: mmtt.organization_id organization_id

Line 5993: mtl_onhand_quantities_detail moq

5989: , to_char(NULL) transfer_subinventory_code
5990: , to_number(NULL) transfer_locator_id
5991: , moq.status_id -- Onhand Material Status Support
5992: FROM
5993: mtl_onhand_quantities_detail moq
5994: UNION ALL
5995: -- pending transactions in mmtt, lot in MMTT
5996: SELECT
5997: mmtt.organization_id organization_id

Line 6368: mtl_onhand_quantities_detail moq

6364: , to_number(NULL) transaction_action_id
6365: , to_char(NULL) transfer_subinventory_code
6366: , to_number(NULL) transfer_locator_id
6367: FROM
6368: mtl_onhand_quantities_detail moq
6369: UNION ALL
6370: -- pending transactions in mmtt, lot in MMTT
6371: SELECT
6372: mmtt.organization_id organization_id

Line 6650: mtl_onhand_quantities_detail moq

6646: , to_char(NULL) transfer_subinventory_code
6647: , to_number(NULL) transfer_locator_id
6648: , moq.status_id -- Onhand Material Status Support
6649: FROM
6650: mtl_onhand_quantities_detail moq
6651: UNION ALL
6652: -- pending transactions in mmtt, lot in MMTT
6653: SELECT
6654: mmtt.organization_id organization_id

Line 7044: mtl_onhand_quantities_detail moq

7040: , to_number(NULL) transaction_action_id
7041: , to_char(NULL) transfer_subinventory_code
7042: , to_number(NULL) transfer_locator_id
7043: FROM
7044: mtl_onhand_quantities_detail moq
7045: GROUP BY moq.organization_id,moq.inventory_item_id,moq.revision,
7046: moq.subinventory_code,moq.locator_id,moq.lot_number,
7047: moq.lpn_id,moq.cost_group_id
7048: UNION ALL

Line 7327: mtl_onhand_quantities_detail moq

7323: , to_number(NULL) transaction_action_id
7324: , to_char(NULL) transfer_subinventory_code
7325: , to_number(NULL) transfer_locator_id
7326: FROM
7327: mtl_onhand_quantities_detail moq
7328: GROUP BY moq.organization_id,moq.inventory_item_id,moq.revision,
7329: moq.subinventory_code,moq.locator_id,moq.lot_number,
7330: moq.lpn_id,moq.cost_group_id
7331: UNION ALL

Line 7747: mtl_onhand_quantities_detail moq

7743: , to_number(NULL) transaction_action_id
7744: , to_char(NULL) transfer_subinventory_code
7745: , to_number(NULL) transfer_locator_id
7746: FROM
7747: mtl_onhand_quantities_detail moq
7748: GROUP BY moq.organization_id,moq.inventory_item_id,moq.revision,
7749: moq.subinventory_code,moq.locator_id,moq.lot_number,
7750: moq.lpn_id,moq.cost_group_id
7751: UNION ALL