DBA Data[Home] [Help]

APPS.DPP_UTILITY_PVT dependencies on MTL_PARAMETERS

Line 867: mtl_parameters mp,

863: msi.concatenated_segments,
864: msi.description
865: FROM
866: mtl_system_items_kfv msi,
867: mtl_parameters mp,
868: financials_system_params_all fspa,
869: oe_order_lines_all oola,
870: dpp_transaction_lines_all dtla
871: WHERE

Line 1042: mtl_parameters mp

1038: moqd.transaction_uom_code
1039: FROM
1040: mtl_onhand_quantities_detail moqd,
1041: org_organization_definitions ood,
1042: mtl_parameters mp
1043: WHERE
1044: moqd.organization_id = ood.organization_id AND
1045: moqd.inventory_item_id = p_inventory_item_id AND
1046: mp.organization_id = ood.organization_id AND

Line 1065: mtl_parameters mp

1061: ood.organization_id warehouse_id
1062: FROM
1063: mtl_onhand_quantities_detail moqd,
1064: org_organization_definitions ood,
1065: mtl_parameters mp
1066: WHERE
1067: moqd.organization_id = ood.organization_id AND
1068: moqd.inventory_item_id = p_inventory_item_id AND
1069: ood.operating_unit = p_org_id AND

Line 1091: mtl_parameters mp

1087: SUM(moqd.transaction_quantity) sum
1088: FROM
1089: mtl_onhand_quantities_detail moqd,
1090: org_organization_definitions ood,
1091: mtl_parameters mp
1092: WHERE
1093: moqd.organization_id = ood.organization_id AND
1094: moqd.inventory_item_id = p_inventory_item_id AND
1095: ood.operating_unit = p_org_id AND

Line 1153: mtl_parameters mp

1149: BEGIN
1150: SELECT primary_uom_code
1151: INTO l_primary_uom_code
1152: FROM mtl_system_items msi,
1153: mtl_parameters mp
1154: WHERE inventory_item_id = l_covered_inv_tbl(i).inventory_item_id
1155: AND mp.organization_id = msi.organization_id
1156: AND mp.organization_id = mp.master_organization_id
1157: AND rownum = 1;

Line 1221: mtl_parameters mp

1217: moqd.transaction_uom_code
1218: FROM
1219: mtl_onhand_quantities_detail moqd,
1220: org_organization_definitions ood,
1221: mtl_parameters mp
1222: WHERE
1223: moqd.organization_id = ood.organization_id AND
1224: moqd.inventory_item_id = p_inventory_item_id AND
1225: mp.organization_id = ood.organization_id AND

Line 1244: mtl_parameters mp

1240: ood.organization_id warehouse_id
1241: FROM
1242: mtl_onhand_quantities_detail moqd,
1243: org_organization_definitions ood,
1244: mtl_parameters mp
1245: WHERE
1246: moqd.organization_id = ood.organization_id AND
1247: moqd.inventory_item_id = p_inventory_item_id AND
1248: ood.operating_unit = p_org_id AND

Line 1270: mtl_parameters mp

1266: SUM(moqd.transaction_quantity) Onhand_quantity
1267: FROM
1268: mtl_onhand_quantities_detail moqd,
1269: org_organization_definitions ood,
1270: mtl_parameters mp
1271: WHERE
1272: moqd.organization_id = ood.organization_id AND
1273: moqd.inventory_item_id = p_inventory_item_id AND
1274: ood.operating_unit = p_org_id AND

Line 1464: mtl_parameters mp

1460: BEGIN
1461: SELECT primary_uom_code
1462: INTO l_primary_uom_code
1463: FROM mtl_system_items msi,
1464: mtl_parameters mp
1465: WHERE inventory_item_id = l_inventorydetails_tbl(i).inventory_item_id
1466: AND mp.organization_id = msi.organization_id
1467: AND mp.organization_id = mp.master_organization_id
1468: AND rownum = 1;