APPS.DPP_COVEREDINVENTORY_PVT dependencies on MTL_PARAMETERS

Line 67: mtl_parameters mp

63: sum(moqd.transaction_quantity) onhand_qty,
64: moqd.transaction_uom_code
65: FROM mtl_onhand_quantities_detail moqd,
66: org_organization_definitions ood,
67: mtl_parameters mp
68: WHERE moqd.organization_id = ood.organization_id
69: AND moqd.inventory_item_id = p_inventory_item_id
70: AND mp.organization_id = ood.organization_id
71: AND NVL(ood.disable_date,SYSDATE + 1) > SYSDATE

Line 92: mtl_parameters mp

88: ood.organization_id warehouse_id
89: FROM
90: mtl_onhand_quantities_detail moqd,
91: org_organization_definitions ood,
92: mtl_parameters mp
93: WHERE moqd.organization_id = ood.organization_id
94: AND moqd.inventory_item_id = p_inventory_item_id
95: AND ood.operating_unit = p_org_id
96: AND mp.organization_id = ood.organization_id

Line 115: mtl_parameters mp

111: SUM(moqd.transaction_quantity) sum
112: FROM
113: mtl_onhand_quantities_detail moqd,
114: org_organization_definitions ood,
115: mtl_parameters mp
116: WHERE
117: moqd.organization_id = ood.organization_id AND
118: moqd.inventory_item_id = p_inventory_item_id AND
119: ood.operating_unit = p_org_id AND

Line 227: mtl_parameters mp

223: BEGIN
224: SELECT primary_uom_code
225: INTO l_primary_uom_code
226: FROM mtl_system_items msi,
227: mtl_parameters mp
228: WHERE inventory_item_id = l_covered_inv_tbl(i).inventory_item_id
229: AND mp.organization_id = msi.organization_id
230: AND mp.organization_id = mp.master_organization_id
231: AND rownum = 1;