DBA Data[Home] [Help]

APPS.DPP_UTILITY_PVT dependencies on MTL_ONHAND_QUANTITIES_DETAIL

Line 1040: mtl_onhand_quantities_detail moqd,

1036: then moqd.transaction_quantity else 0 end) covered_qty,
1037: sum(moqd.transaction_quantity) onhand_qty,
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

Line 1063: mtl_onhand_quantities_detail moqd,

1059: SUM(moqd.transaction_quantity) sum,
1060: ood.organization_name warehouse,
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

Line 1089: mtl_onhand_quantities_detail moqd,

1085: SELECT
1086: TRUNC(NVL(moqd.orig_date_received,moqd.date_received)) date_received,
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

Line 1219: mtl_onhand_quantities_detail moqd,

1215: then moqd.transaction_quantity else 0 end) covered_qty,
1216: sum(moqd.transaction_quantity) onhand_qty,
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

Line 1242: mtl_onhand_quantities_detail moqd,

1238: SUM(moqd.transaction_quantity) Covered_quantity,
1239: ood.organization_name warehouse,
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

Line 1268: mtl_onhand_quantities_detail moqd,

1264: SELECT
1265: (NVL(moqd.orig_date_received,moqd.date_received)) date_received,
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