APPS.INV_DIAG_OH_QTY_ZERO dependencies on MTL_ONHAND_QUANTITIES_DETAIL

Line 36: FROM mtl_onhand_quantities_detail moqd

32:
33: CURSOR c_tnx (cp_org_id IN NUMBER,
34: cp_item_id IN NUMBER) IS
35: SELECT moqd.create_transaction_id
36: FROM mtl_onhand_quantities_detail moqd
37: WHERE moqd.subinventory_code is not null
38: AND ( moqd.primary_transaction_quantity = 0
39: OR moqd.transaction_quantity = 0 )
40: AND moqd.organization_id = NVL(cp_org_id,moqd.organization_id)

Line 62: ' from mtl_onhand_quantities_detail moqd, mtl_parameters mp,' ||

58: ' , moqd.locator_id "Stock Locator"' ||
59: ' , moqd.revision "Rev"' ||
60: ' , moqd.primary_transaction_quantity "Prim Qty"' ||
61: ' , moqd.create_transaction_id "Create txn_id"' ||
62: ' from mtl_onhand_quantities_detail moqd, mtl_parameters mp,' ||
63: ' mtl_item_flexfields mif' ||
64: ' where subinventory_code is not null ' ||
65: ' and moqd.organization_id = mp.organization_id' ||
66: ' and (primary_transaction_quantity = 0 ' ||