APPS.INVIDIT3 dependencies on MTL_ONHAND_QUANTITIES_DETAIL

Line 301: FROM mtl_onhand_quantities_detail -- Bug:2687570

297: OR x_onhand_grade IS NOT NULL
298: THEN
299:
300: SELECT COUNT(1) INTO onhand_org_count
301: FROM mtl_onhand_quantities_detail -- Bug:2687570
302: WHERE inventory_item_id = p_item_id
303: AND organization_id = p_org_id
304: AND ROWNUM = 1;
305:

Line 308: FROM mtl_onhand_quantities_detail -- Bug:2687570

304: AND ROWNUM = 1;
305:
306: IF (onhand_org_count <> 1) THEN
307: SELECT COUNT(1) INTO onhand_master_count
308: FROM mtl_onhand_quantities_detail -- Bug:2687570
309: WHERE inventory_item_id = p_item_id
310: AND (organization_id IN (SELECT organization_id
311: FROM mtl_parameters
312: WHERE master_organization_id = p_master_org))

Line 755: from mtl_onhand_quantities_detail moh -- Bug:2687570

751: if x_onhand_all IS NOT NULL THEN
752: select count(*) into X_onhand_all
753: from dual
754: where exists ( select 'x'
755: from mtl_onhand_quantities_detail moh -- Bug:2687570
756: where moh.inventory_item_id = p_item_id
757: and moh.organization_id in ( select mp.organization_id
758: from mtl_parameters mp
759: where mp.master_organization_id = p_master_org));

Line 1132: from mtl_onhand_quantities_detail -- Bug:2687570

1128: -- X_cost_txn will have either 0 or 1
1129: IF X_cost_txn IS NOT NULL THEN
1130: select count(1)
1131: into cost_moq
1132: from mtl_onhand_quantities_detail -- Bug:2687570
1133: where inventory_item_id = p_item_id
1134: and organization_id in
1135: (select organization_id
1136: from mtl_parameters

Line 1143: from mtl_onhand_quantities_detail -- Bug:2687570

1139:
1140: if (cost_moq <> 1) then
1141: select count(1)
1142: into cost_moq2
1143: from mtl_onhand_quantities_detail -- Bug:2687570
1144: where inventory_item_id = p_item_id
1145: and organization_id in
1146: (select organization_id
1147: from mtl_parameters