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.OPI_DBI_WMS_CAPACITY_UTZ_PKG dependencies on MTL_ONHAND_QUANTITIES

Line 1131: -- stored in MTL_ONHAND_QUANTITIES.

1127: l_stmt_id := 30;
1128: -- Extract the item storage details for all organizations that are
1129: -- WMS enabled. No need to specifically filter out
1130: -- process organizations since their locator setup is not
1131: -- stored in MTL_ONHAND_QUANTITIES.
1132: --
1133: -- Collecting 3 measures:
1134: -- 1. Quantity stored in any locator with weight or volume capacity
1135: -- defined.

Line 1343: mtl_onhand_quantities moq,

1339: sum (decode (volume_capacity_rep,
1340: NULL, NULL,
1341: moq.transaction_quantity)) volume_qty
1342: FROM
1343: mtl_onhand_quantities moq,
1344: mtl_parameters mp,
1345: opi_dbi_wms_curr_utz_sub_stg loc,
1346: eni_oltp_item_star items
1347: WHERE mp.wms_enabled_flag = 'Y'