eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.DPP_UTILITY_PVT dependencies on MTL_ONHAND_QUANTITIES_DETAIL

Line 1079: mtl_onhand_quantities_detail moqd,

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

Line 1102: mtl_onhand_quantities_detail moqd,

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

Line 1128: mtl_onhand_quantities_detail moqd,

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

Line 1255: mtl_onhand_quantities_detail moqd,

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

Line 1278: mtl_onhand_quantities_detail moqd,

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

Line 1304: mtl_onhand_quantities_detail moqd,

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