APPS.INVIDIT3 dependencies on MTL_ONHAND_QUANTITIES_DETAIL

Line 315: FROM mtl_onhand_quantities_detail -- Bug:2687570

311: OR x_onhand_grade IS NOT NULL
312: THEN
313:
314: SELECT COUNT(1) INTO onhand_org_count
315: FROM mtl_onhand_quantities_detail -- Bug:2687570
316: WHERE inventory_item_id = p_item_id
317: AND organization_id = p_org_id
318: AND ROWNUM = 1;
319:

Line 322: FROM mtl_onhand_quantities_detail -- Bug:2687570

318: AND ROWNUM = 1;
319:
320: IF (onhand_org_count <> 1) THEN
321: SELECT COUNT(1) INTO onhand_master_count
322: FROM mtl_onhand_quantities_detail -- Bug:2687570
323: WHERE inventory_item_id = p_item_id
324: AND (organization_id IN (SELECT organization_id
325: FROM mtl_parameters
326: WHERE master_organization_id = p_master_org))

Line 789: from mtl_onhand_quantities_detail moh -- Bug:2687570

785: if x_onhand_all IS NOT NULL THEN
786: select count(*) into X_onhand_all
787: from dual
788: where exists ( select 'x'
789: from mtl_onhand_quantities_detail moh -- Bug:2687570
790: where moh.inventory_item_id = p_item_id
791: and moh.organization_id in ( select mp.organization_id
792: from mtl_parameters mp
793: where mp.master_organization_id = p_master_org));

Line 1204: mtl_onhand_quantities_detail

1200: -- Use local variables for each sql statement, return 1 variable to form
1201: -- X_cost_txn will have either 0 or 1 or 2
1202: /* Bug 14334921 START
1203: We need to perform the below checks on the tables
1204: mtl_onhand_quantities_detail
1205: mtl_material_transactions_temp
1206: mtl_material_transactions
1207: while updating the Costing_enabled_flag or inventory_asset_flag.
1208: In addition,

Line 1227: from mtl_onhand_quantities_detail -- Bug:2687570

1223:
1224: IF X_cost_txn IS NOT NULL THEN
1225: select count(1)
1226: into cost_moq
1227: from mtl_onhand_quantities_detail -- Bug:2687570
1228: where inventory_item_id = p_item_id
1229: and organization_id = p_org_id
1230: /* Bug 14334921 (select organization_id
1231: from mtl_parameters

Line 1238: from mtl_onhand_quantities_detail -- Bug:2687570

1234:
1235: if (cost_moq <> 1) then
1236: select count(1) + count(2)
1237: into cost_moq2
1238: from mtl_onhand_quantities_detail -- Bug:2687570
1239: where inventory_item_id = p_item_id
1240: and organization_id in
1241: (select organization_id
1242: from mtl_parameters