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 HR_ALL_ORGANIZATION_UNITS_VL

Line 201: hr_all_organization_units_vl orgs

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
204: AND mp.wms_enabled_flag = ''Y''
205: AND mp.process_enabled_flag <> ''Y''

Line 515: hr_all_organization_units_vl orgs

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
518: AND mp.wms_enabled_flag = ''Y''
519: AND mp.process_enabled_flag <> ''Y''

Line 766: hr_all_organization_units_vl orgs,

762: WHERE utilized_volume/volume_qty < 0
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

Line 799: hr_all_organization_units_vl orgs,

795: WHERE stored_weight/weight_qty < 0
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

Line 1091: hr_all_organization_units_vl orgs

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'
1095: AND mp.organization_id = stg.organization_id

Line 1112: hr_all_organization_units_vl orgs

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'
1116: AND mp.organization_id = stg.organization_id