APPS.OPI_DBI_WMS_UTILITY_PKG dependencies on ENI_OLTP_ITEM_STAR

Line 166: eni_oltp_item_star items

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'
170: AND ( items.weight_uom_code IS NULL

Line 200: eni_oltp_item_star items,

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

Line 765: eni_oltp_item_star items,

761: FROM opi_dbi_wms_curr_utz_item_f
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

Line 798: eni_oltp_item_star items,

794: FROM opi_dbi_wms_curr_utz_item_f
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