APPS.DPP_UTILITY_PVT dependencies on MTL_PARAMETERS

Line 829: mtl_parameters mp,

825: msi.concatenated_segments,
826: msi.description
827: FROM
828: mtl_system_items_kfv msi,
829: mtl_parameters mp,
830: financials_system_params_all fspa,
831: oe_order_lines_all oola,
832: dpp_transaction_lines_all dtla
833: WHERE

Line 921: mtl_parameters mp,

917: msi.concatenated_segments,
918: msi.description
919: FROM
920: mtl_system_items_kfv msi,
921: mtl_parameters mp,
922: financials_system_params_all fspa,
923: dpp_transaction_lines_all dtla
924: WHERE
925: dtla.transaction_header_id = TO_NUMBER(p_search_text1) AND

Line 1081: mtl_parameters mp

1077: moqd.transaction_uom_code
1078: FROM
1079: mtl_onhand_quantities_detail moqd,
1080: org_organization_definitions ood,
1081: mtl_parameters mp
1082: WHERE
1083: moqd.organization_id = ood.organization_id AND
1084: moqd.inventory_item_id = p_inventory_item_id AND
1085: mp.organization_id = ood.organization_id AND

Line 1104: mtl_parameters mp

1100: ood.organization_id warehouse_id
1101: FROM
1102: mtl_onhand_quantities_detail moqd,
1103: org_organization_definitions ood,
1104: mtl_parameters mp
1105: WHERE
1106: moqd.organization_id = ood.organization_id AND
1107: moqd.inventory_item_id = p_inventory_item_id AND
1108: ood.operating_unit = p_org_id AND

Line 1130: mtl_parameters mp

1126: SUM(moqd.transaction_quantity) sum
1127: FROM
1128: mtl_onhand_quantities_detail moqd,
1129: org_organization_definitions ood,
1130: mtl_parameters mp
1131: WHERE
1132: moqd.organization_id = ood.organization_id AND
1133: moqd.inventory_item_id = p_inventory_item_id AND
1134: ood.operating_unit = p_org_id AND

Line 1192: mtl_parameters mp

1188: BEGIN
1189: SELECT primary_uom_code
1190: INTO l_primary_uom_code
1191: FROM mtl_system_items msi,
1192: mtl_parameters mp
1193: WHERE inventory_item_id = l_covered_inv_tbl(i).inventory_item_id
1194: AND mp.organization_id = msi.organization_id
1195: AND mp.organization_id = mp.master_organization_id
1196: AND rownum = 1;

Line 1257: mtl_parameters mp

1253: moqd.transaction_uom_code
1254: FROM
1255: mtl_onhand_quantities_detail moqd,
1256: org_organization_definitions ood,
1257: mtl_parameters mp
1258: WHERE
1259: moqd.organization_id = ood.organization_id AND
1260: moqd.inventory_item_id = p_inventory_item_id AND
1261: mp.organization_id = ood.organization_id AND

Line 1280: mtl_parameters mp

1276: ood.organization_id warehouse_id
1277: FROM
1278: mtl_onhand_quantities_detail moqd,
1279: org_organization_definitions ood,
1280: mtl_parameters mp
1281: WHERE
1282: moqd.organization_id = ood.organization_id AND
1283: moqd.inventory_item_id = p_inventory_item_id AND
1284: ood.operating_unit = p_org_id AND

Line 1306: mtl_parameters mp

1302: SUM(moqd.transaction_quantity) Onhand_quantity
1303: FROM
1304: mtl_onhand_quantities_detail moqd,
1305: org_organization_definitions ood,
1306: mtl_parameters mp
1307: WHERE
1308: moqd.organization_id = ood.organization_id AND
1309: moqd.inventory_item_id = p_inventory_item_id AND
1310: ood.operating_unit = p_org_id AND

Line 1500: mtl_parameters mp

1496: BEGIN
1497: SELECT primary_uom_code
1498: INTO l_primary_uom_code
1499: FROM mtl_system_items msi,
1500: mtl_parameters mp
1501: WHERE inventory_item_id = l_inventorydetails_tbl(i).inventory_item_id
1502: AND mp.organization_id = msi.organization_id
1503: AND mp.organization_id = mp.master_organization_id
1504: AND rownum = 1;