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_UTILITY_PKG dependencies on MTL_PARAMETERS

Line 165: FROM mtl_parameters mp,

161: -- Cursor to count how many rows are missing
162: CURSOR item_setup_missing_count_csr IS
163: SELECT
164: count (*)
165: FROM mtl_parameters mp,
166: eni_oltp_item_star items
167: WHERE mp.organization_id = items.organization_id
168: AND mp.wms_enabled_flag = 'Y'
169: AND mp.process_enabled_flag <> 'Y'

Line 199: FROM mtl_parameters mp,

195: 2 /*C_VOL_MISSING*/
196: ELSE
197: 3 /*C_NOTHING_MISSING*/
198: END vol_missing_flag
199: FROM mtl_parameters mp,
200: eni_oltp_item_star items,
201: hr_all_organization_units_vl orgs
202: WHERE mp.organization_id = orgs.organization_id
203: AND mp.organization_id = items.organization_id

Line 477: FROM mtl_parameters mp,

473:
474: CURSOR loc_setup_missing_count_csr IS
475: SELECT
476: count (*)
477: FROM mtl_parameters mp,
478: mtl_item_locations mil
479: WHERE mp.organization_id = mil.organization_id
480: AND mp.wms_enabled_flag = 'Y'
481: AND mp.process_enabled_flag <> 'Y'

Line 513: FROM mtl_parameters mp,

509: 2 /*C_VOL_MISSING*/
510: ELSE
511: 0 /*C_NOTHING_MISSING*/
512: END vol_missing_flag
513: FROM mtl_parameters mp,
514: mtl_item_locations mil,
515: hr_all_organization_units_vl orgs
516: WHERE mp.organization_id = orgs.organization_id
517: AND mp.organization_id = mil.organization_id

Line 767: mtl_parameters mp

763: AND aggregation_level_flag = C_ITEM_AGGR_LEVEL
764: ) errors,
765: eni_oltp_item_star items,
766: hr_all_organization_units_vl orgs,
767: mtl_parameters mp
768: WHERE errors.organization_id = orgs.organization_id
769: AND errors.organization_id = items.organization_id
770: AND errors.item_org_id = items.id
771: AND errors.organization_id = mp.organization_id

Line 800: mtl_parameters mp

796: AND aggregation_level_flag = C_ITEM_AGGR_LEVEL
797: ) errors,
798: eni_oltp_item_star items,
799: hr_all_organization_units_vl orgs,
800: mtl_parameters mp
801: WHERE errors.organization_id = orgs.organization_id
802: AND errors.organization_id = items.organization_id
803: AND errors.item_org_id = items.id
804: AND errors.organization_id = mp.organization_id

Line 1090: mtl_parameters mp,

1086: INV_PROJECT.get_locator (stg.locator_id, stg.organization_id)
1087: loc,
1088: stg.volume_uom_code
1089: FROM opi_dbi_wms_curr_utz_sub_stg stg,
1090: mtl_parameters mp,
1091: hr_all_organization_units_vl orgs
1092: WHERE mp.organization_id = orgs.organization_id
1093: AND mp.wms_enabled_flag = 'Y'
1094: AND mp.process_enabled_flag <> 'Y'

Line 1111: mtl_parameters mp,

1107: INV_PROJECT.get_locator (stg.locator_id, stg.organization_id)
1108: loc,
1109: stg.weight_uom_code
1110: FROM opi_dbi_wms_curr_utz_sub_stg stg,
1111: mtl_parameters mp,
1112: hr_all_organization_units_vl orgs
1113: WHERE mp.organization_id = orgs.organization_id
1114: AND mp.wms_enabled_flag = 'Y'
1115: AND mp.process_enabled_flag <> 'Y'