APPS.INV_DIAG_PI_SUBLOC dependencies on MTL_ONHAND_QUANTITIES_DETAIL

Line 37: from mtl_onhand_quantities_detail moqd

33: moqd.revision,
34: moqd.primary_transaction_quantity,
35: moqd.create_transaction_id,
36: moqd.update_transaction_id
37: from mtl_onhand_quantities_detail moqd
38: where moqd.locator_id is not null
39: and moqd.organization_id = NVL(cp_n_org_id, moqd.organization_id)
40: and not exists (select 1 from mtl_item_locations mil
41: where mil.organization_id = moqd.organization_id

Line 79: ' from mtl_onhand_quantities_detail moqd,' ||

75: ' , moqd.revision "Rev" ' ||
76: ' , moqd.primary_transaction_quantity "Prim Qty" ' ||
77: ' , moqd.create_transaction_id "Create txn_id"' ||
78: ' , moqd.update_transaction_id "Update trx_id"' ||
79: ' from mtl_onhand_quantities_detail moqd,' ||
80: ' mtl_item_flexfields mif' ||
81: ' where moqd.locator_id is not null ' ;
82: IF l_org_id IS NOT NULL THEN
83: sqltxt := sqltxt || ' AND moqd.organization_id = ' || l_org_id ;