VIEW: APPS.OE_ITEMS_ORD_MV

Source

View Text - Preformatted

SELECT mv.ITEM, mv.ITEM_ID, mv.ITEM_DESCRIPTION, mv.INVENTORY_ITEM_ID, mv.INVENTORY_ITEM, mv.ITEM_IDENTIFIER_TYPE, mv.SOLD_TO_ORG_ID, mv.ORGANIZATION_ID, mv.ITEM_STATUS, mv.CROSS_REF_STATUS, mv.ADDRESS, mv.CUST_ADDRESS, mv.ITEM_DEFINITION_LEVEL, mv.RANK, mv.SITE_USE_ID, mv.ITEM_DEFINITION_LEVEL_CODE, mv.LANGUAGE, mv.CATEGORY_ID, mv.ORG_INDEPENDENT_FLAG, mv.CROSS_REF_ORG_ID from oe_item_orderability io_hdr, oe_items_mv mv WHERE io_hdr.org_id = OE_ITORD_UTIL.get_operating_unit_id and io_hdr.item_level = 'I' and io_hdr.generally_available = 'N' and io_hdr.enable_flag = 'Y' and exists ( select 1 from oe_item_orderability_rules io_rules where io_rules.orderability_id = io_hdr.orderability_id and io_rules.enable_flag = 'Y' and (io_rules.customer_id = OE_ITORD_UTIL.get_customer_id or io_rules.customer_class_id = OE_ITORD_UTIL.get_customer_class_id or io_rules.customer_category_code = OE_ITORD_UTIL.get_customer_category_code or INSTR(OE_ITORD_UTIL.get_region_ids, ','||to_char(io_rules.region_id)||',' )!= 0 or io_rules.order_type_id = OE_ITORD_UTIL.get_order_type_id or io_rules.ship_to_location_id = OE_ITORD_UTIL.get_ship_to_org_id or io_rules.sales_channel_code = OE_ITORD_UTIL.get_sales_channel_code or io_rules.sales_person_id = OE_ITORD_UTIL.get_salesrep_id or io_rules.end_customer_id = OE_ITORD_UTIL.get_end_customer_id or io_rules.bill_to_location_id = OE_ITORD_UTIL.get_invoice_to_org_id or io_rules.deliver_to_location_id = OE_ITORD_UTIL.get_deliver_to_org_id ) ) and mv.organization_id = OE_ITORD_UTIL.get_item_validation_org_id and mv.language = userenv('LANG') and mv.inventory_item_id = io_hdr.inventory_item_id UNION ALL select mv.ITEM, mv.ITEM_ID, mv.ITEM_DESCRIPTION, mv.INVENTORY_ITEM_ID, mv.INVENTORY_ITEM, mv.ITEM_IDENTIFIER_TYPE, mv.SOLD_TO_ORG_ID, mv.ORGANIZATION_ID, mv.ITEM_STATUS, mv.CROSS_REF_STATUS, mv.ADDRESS, mv.CUST_ADDRESS, mv.ITEM_DEFINITION_LEVEL, mv.RANK, mv.SITE_USE_ID, mv.ITEM_DEFINITION_LEVEL_CODE, mv.LANGUAGE, mv.CATEGORY_ID, mv.ORG_INDEPENDENT_FLAG, mv.CROSS_REF_ORG_ID from oe_item_orderability io_hdr, oe_items_mv mv where io_hdr.org_id = OE_ITORD_UTIL.get_operating_unit_id and io_hdr.item_level = 'C' and io_hdr.generally_available = 'N' and io_hdr.enable_flag = 'Y' and exists ( select 1 from oe_item_orderability_rules io_rules where io_rules.orderability_id = io_hdr.orderability_id and io_rules.enable_flag = 'Y' and (io_rules.customer_id = OE_ITORD_UTIL.get_customer_id or io_rules.customer_class_id = OE_ITORD_UTIL.get_customer_class_id or io_rules.customer_category_code = OE_ITORD_UTIL.get_customer_category_code or INSTR(OE_ITORD_UTIL.get_region_ids, ','||to_char(io_rules.region_id)||',' )!= 0 or io_rules.order_type_id = OE_ITORD_UTIL.get_order_type_id or io_rules.ship_to_location_id = OE_ITORD_UTIL.get_ship_to_org_id or io_rules.sales_channel_code = OE_ITORD_UTIL.get_sales_channel_code or io_rules.sales_person_id = OE_ITORD_UTIL.get_salesrep_id or io_rules.end_customer_id = OE_ITORD_UTIL.get_end_customer_id or io_rules.bill_to_location_id = OE_ITORD_UTIL.get_invoice_to_org_id or io_rules.deliver_to_location_id = OE_ITORD_UTIL.get_deliver_to_org_id ) ) and mv.organization_id = OE_ITORD_UTIL.get_item_validation_org_id and mv.language = userenv('LANG') and mv.category_id = io_hdr.item_category_id UNION ALL select mv.ITEM, mv.ITEM_ID, mv.ITEM_DESCRIPTION, mv.INVENTORY_ITEM_ID, mv.INVENTORY_ITEM, mv.ITEM_IDENTIFIER_TYPE, mv.SOLD_TO_ORG_ID, mv.ORGANIZATION_ID, mv.ITEM_STATUS, mv.CROSS_REF_STATUS, mv.ADDRESS, mv.CUST_ADDRESS, mv.ITEM_DEFINITION_LEVEL, mv.RANK, mv.SITE_USE_ID, mv.ITEM_DEFINITION_LEVEL_CODE, mv.LANGUAGE, mv.CATEGORY_ID, mv.ORG_INDEPENDENT_FLAG, mv.CROSS_REF_ORG_ID from oe_items_mv mv, oe_item_orderability io_hdr where io_hdr.org_id = OE_ITORD_UTIL.get_operating_unit_id and io_hdr.item_level = 'I' and io_hdr.generally_available = 'Y' and io_hdr.enable_flag = 'Y' and not exists ( select 1 from oe_item_orderability_rules io_rules where io_rules.orderability_id = io_hdr.orderability_id and io_rules.enable_flag = 'Y' and (io_rules.customer_id = OE_ITORD_UTIL.get_customer_id or io_rules.customer_class_id = OE_ITORD_UTIL.get_customer_class_id or io_rules.customer_category_code = OE_ITORD_UTIL.get_customer_category_code or INSTR(OE_ITORD_UTIL.get_region_ids, ','||to_char(io_rules.region_id)||',' )!= 0 or io_rules.order_type_id = OE_ITORD_UTIL.get_order_type_id or io_rules.ship_to_location_id = OE_ITORD_UTIL.get_ship_to_org_id or io_rules.sales_channel_code = OE_ITORD_UTIL.get_sales_channel_code or io_rules.sales_person_id = OE_ITORD_UTIL.get_salesrep_id or io_rules.end_customer_id = OE_ITORD_UTIL.get_end_customer_id or io_rules.bill_to_location_id = OE_ITORD_UTIL.get_invoice_to_org_id or io_rules.deliver_to_location_id = OE_ITORD_UTIL.get_deliver_to_org_id ) ) and mv.organization_id = OE_ITORD_UTIL.get_item_validation_org_id and mv.language = userenv('LANG') and mv.inventory_item_id = io_hdr.inventory_item_id UNION ALL select mv.ITEM, mv.ITEM_ID, mv.ITEM_DESCRIPTION, mv.INVENTORY_ITEM_ID, mv.INVENTORY_ITEM, mv.ITEM_IDENTIFIER_TYPE, mv.SOLD_TO_ORG_ID, mv.ORGANIZATION_ID, mv.ITEM_STATUS, mv.CROSS_REF_STATUS, mv.ADDRESS, mv.CUST_ADDRESS, mv.ITEM_DEFINITION_LEVEL, mv.RANK, mv.SITE_USE_ID, mv.ITEM_DEFINITION_LEVEL_CODE, mv.LANGUAGE, mv.CATEGORY_ID, mv.ORG_INDEPENDENT_FLAG, mv.CROSS_REF_ORG_ID from oe_items_mv mv, oe_item_orderability io_hdr where io_hdr.org_id = OE_ITORD_UTIL.get_operating_unit_id and io_hdr.item_level = 'C' and io_hdr.generally_available = 'Y' and io_hdr.enable_flag = 'Y' and not exists ( select 1 from oe_item_orderability_rules io_rules where io_rules.orderability_id = io_hdr.orderability_id and io_rules.enable_flag = 'Y' and (io_rules.customer_id = OE_ITORD_UTIL.get_customer_id or io_rules.customer_class_id = OE_ITORD_UTIL.get_customer_class_id or io_rules.customer_category_code = OE_ITORD_UTIL.get_customer_category_code or INSTR(OE_ITORD_UTIL.get_region_ids, ','||to_char(io_rules.region_id)||',' )!= 0 or io_rules.order_type_id = OE_ITORD_UTIL.get_order_type_id or io_rules.ship_to_location_id = OE_ITORD_UTIL.get_ship_to_org_id or io_rules.sales_channel_code = OE_ITORD_UTIL.get_sales_channel_code or io_rules.sales_person_id = OE_ITORD_UTIL.get_salesrep_id or io_rules.end_customer_id = OE_ITORD_UTIL.get_end_customer_id or io_rules.bill_to_location_id = OE_ITORD_UTIL.get_invoice_to_org_id or io_rules.deliver_to_location_id = OE_ITORD_UTIL.get_deliver_to_org_id ) ) and mv.organization_id = OE_ITORD_UTIL.get_item_validation_org_id and mv.language = userenv('LANG') and mv.category_id = io_hdr.item_category_id UNION ALL select mv.ITEM, mv.ITEM_ID, mv.ITEM_DESCRIPTION, mv.INVENTORY_ITEM_ID, mv.INVENTORY_ITEM, mv.ITEM_IDENTIFIER_TYPE, mv.SOLD_TO_ORG_ID, mv.ORGANIZATION_ID, mv.ITEM_STATUS, mv.CROSS_REF_STATUS, mv.ADDRESS, mv.CUST_ADDRESS, mv.ITEM_DEFINITION_LEVEL, mv.RANK, mv.SITE_USE_ID, mv.ITEM_DEFINITION_LEVEL_CODE, mv.LANGUAGE, mv.CATEGORY_ID, mv.ORG_INDEPENDENT_FLAG, mv.CROSS_REF_ORG_ID from oe_items_mv mv where mv.organization_id = OE_ITORD_UTIL.get_item_validation_org_id and mv.language = userenv('LANG') and not exists ( select 1 from oe_item_orderability io_hdr where io_hdr.inventory_item_id = mv.inventory_item_id and io_hdr.org_id = OE_ITORD_UTIL.get_operating_unit_id and io_hdr.item_level = 'I' and io_hdr.enable_flag = 'Y' UNION ALL select 1 from oe_item_orderability io_hdr where io_hdr.item_category_id = mv.category_id and io_hdr.org_id = OE_ITORD_UTIL.get_operating_unit_id and io_hdr.item_level = 'C' and io_hdr.enable_flag = 'Y' )

View Text - HTML Formatted

SELECT MV.ITEM
, MV.ITEM_ID
, MV.ITEM_DESCRIPTION
, MV.INVENTORY_ITEM_ID
, MV.INVENTORY_ITEM
, MV.ITEM_IDENTIFIER_TYPE
, MV.SOLD_TO_ORG_ID
, MV.ORGANIZATION_ID
, MV.ITEM_STATUS
, MV.CROSS_REF_STATUS
, MV.ADDRESS
, MV.CUST_ADDRESS
, MV.ITEM_DEFINITION_LEVEL
, MV.RANK
, MV.SITE_USE_ID
, MV.ITEM_DEFINITION_LEVEL_CODE
, MV.LANGUAGE
, MV.CATEGORY_ID
, MV.ORG_INDEPENDENT_FLAG
, MV.CROSS_REF_ORG_ID
FROM OE_ITEM_ORDERABILITY IO_HDR
, OE_ITEMS_MV MV
WHERE IO_HDR.ORG_ID = OE_ITORD_UTIL.GET_OPERATING_UNIT_ID
AND IO_HDR.ITEM_LEVEL = 'I'
AND IO_HDR.GENERALLY_AVAILABLE = 'N'
AND IO_HDR.ENABLE_FLAG = 'Y'
AND EXISTS ( SELECT 1
FROM OE_ITEM_ORDERABILITY_RULES IO_RULES
WHERE IO_RULES.ORDERABILITY_ID = IO_HDR.ORDERABILITY_ID
AND IO_RULES.ENABLE_FLAG = 'Y'
AND (IO_RULES.CUSTOMER_ID = OE_ITORD_UTIL.GET_CUSTOMER_ID OR IO_RULES.CUSTOMER_CLASS_ID = OE_ITORD_UTIL.GET_CUSTOMER_CLASS_ID OR IO_RULES.CUSTOMER_CATEGORY_CODE = OE_ITORD_UTIL.GET_CUSTOMER_CATEGORY_CODE OR INSTR(OE_ITORD_UTIL.GET_REGION_IDS
, '
, '||TO_CHAR(IO_RULES.REGION_ID)||'
, ' )!= 0 OR IO_RULES.ORDER_TYPE_ID = OE_ITORD_UTIL.GET_ORDER_TYPE_ID OR IO_RULES.SHIP_TO_LOCATION_ID = OE_ITORD_UTIL.GET_SHIP_TO_ORG_ID OR IO_RULES.SALES_CHANNEL_CODE = OE_ITORD_UTIL.GET_SALES_CHANNEL_CODE OR IO_RULES.SALES_PERSON_ID = OE_ITORD_UTIL.GET_SALESREP_ID OR IO_RULES.END_CUSTOMER_ID = OE_ITORD_UTIL.GET_END_CUSTOMER_ID OR IO_RULES.BILL_TO_LOCATION_ID = OE_ITORD_UTIL.GET_INVOICE_TO_ORG_ID OR IO_RULES.DELIVER_TO_LOCATION_ID = OE_ITORD_UTIL.GET_DELIVER_TO_ORG_ID ) )
AND MV.ORGANIZATION_ID = OE_ITORD_UTIL.GET_ITEM_VALIDATION_ORG_ID
AND MV.LANGUAGE = USERENV('LANG')
AND MV.INVENTORY_ITEM_ID = IO_HDR.INVENTORY_ITEM_ID UNION ALL SELECT MV.ITEM
, MV.ITEM_ID
, MV.ITEM_DESCRIPTION
, MV.INVENTORY_ITEM_ID
, MV.INVENTORY_ITEM
, MV.ITEM_IDENTIFIER_TYPE
, MV.SOLD_TO_ORG_ID
, MV.ORGANIZATION_ID
, MV.ITEM_STATUS
, MV.CROSS_REF_STATUS
, MV.ADDRESS
, MV.CUST_ADDRESS
, MV.ITEM_DEFINITION_LEVEL
, MV.RANK
, MV.SITE_USE_ID
, MV.ITEM_DEFINITION_LEVEL_CODE
, MV.LANGUAGE
, MV.CATEGORY_ID
, MV.ORG_INDEPENDENT_FLAG
, MV.CROSS_REF_ORG_ID
FROM OE_ITEM_ORDERABILITY IO_HDR
, OE_ITEMS_MV MV
WHERE IO_HDR.ORG_ID = OE_ITORD_UTIL.GET_OPERATING_UNIT_ID
AND IO_HDR.ITEM_LEVEL = 'C'
AND IO_HDR.GENERALLY_AVAILABLE = 'N'
AND IO_HDR.ENABLE_FLAG = 'Y'
AND EXISTS ( SELECT 1
FROM OE_ITEM_ORDERABILITY_RULES IO_RULES
WHERE IO_RULES.ORDERABILITY_ID = IO_HDR.ORDERABILITY_ID
AND IO_RULES.ENABLE_FLAG = 'Y'
AND (IO_RULES.CUSTOMER_ID = OE_ITORD_UTIL.GET_CUSTOMER_ID OR IO_RULES.CUSTOMER_CLASS_ID = OE_ITORD_UTIL.GET_CUSTOMER_CLASS_ID OR IO_RULES.CUSTOMER_CATEGORY_CODE = OE_ITORD_UTIL.GET_CUSTOMER_CATEGORY_CODE OR INSTR(OE_ITORD_UTIL.GET_REGION_IDS
, '
, '||TO_CHAR(IO_RULES.REGION_ID)||'
, ' )!= 0 OR IO_RULES.ORDER_TYPE_ID = OE_ITORD_UTIL.GET_ORDER_TYPE_ID OR IO_RULES.SHIP_TO_LOCATION_ID = OE_ITORD_UTIL.GET_SHIP_TO_ORG_ID OR IO_RULES.SALES_CHANNEL_CODE = OE_ITORD_UTIL.GET_SALES_CHANNEL_CODE OR IO_RULES.SALES_PERSON_ID = OE_ITORD_UTIL.GET_SALESREP_ID OR IO_RULES.END_CUSTOMER_ID = OE_ITORD_UTIL.GET_END_CUSTOMER_ID OR IO_RULES.BILL_TO_LOCATION_ID = OE_ITORD_UTIL.GET_INVOICE_TO_ORG_ID OR IO_RULES.DELIVER_TO_LOCATION_ID = OE_ITORD_UTIL.GET_DELIVER_TO_ORG_ID ) )
AND MV.ORGANIZATION_ID = OE_ITORD_UTIL.GET_ITEM_VALIDATION_ORG_ID
AND MV.LANGUAGE = USERENV('LANG')
AND MV.CATEGORY_ID = IO_HDR.ITEM_CATEGORY_ID UNION ALL SELECT MV.ITEM
, MV.ITEM_ID
, MV.ITEM_DESCRIPTION
, MV.INVENTORY_ITEM_ID
, MV.INVENTORY_ITEM
, MV.ITEM_IDENTIFIER_TYPE
, MV.SOLD_TO_ORG_ID
, MV.ORGANIZATION_ID
, MV.ITEM_STATUS
, MV.CROSS_REF_STATUS
, MV.ADDRESS
, MV.CUST_ADDRESS
, MV.ITEM_DEFINITION_LEVEL
, MV.RANK
, MV.SITE_USE_ID
, MV.ITEM_DEFINITION_LEVEL_CODE
, MV.LANGUAGE
, MV.CATEGORY_ID
, MV.ORG_INDEPENDENT_FLAG
, MV.CROSS_REF_ORG_ID
FROM OE_ITEMS_MV MV
, OE_ITEM_ORDERABILITY IO_HDR
WHERE IO_HDR.ORG_ID = OE_ITORD_UTIL.GET_OPERATING_UNIT_ID
AND IO_HDR.ITEM_LEVEL = 'I'
AND IO_HDR.GENERALLY_AVAILABLE = 'Y'
AND IO_HDR.ENABLE_FLAG = 'Y'
AND NOT EXISTS ( SELECT 1
FROM OE_ITEM_ORDERABILITY_RULES IO_RULES
WHERE IO_RULES.ORDERABILITY_ID = IO_HDR.ORDERABILITY_ID
AND IO_RULES.ENABLE_FLAG = 'Y'
AND (IO_RULES.CUSTOMER_ID = OE_ITORD_UTIL.GET_CUSTOMER_ID OR IO_RULES.CUSTOMER_CLASS_ID = OE_ITORD_UTIL.GET_CUSTOMER_CLASS_ID OR IO_RULES.CUSTOMER_CATEGORY_CODE = OE_ITORD_UTIL.GET_CUSTOMER_CATEGORY_CODE OR INSTR(OE_ITORD_UTIL.GET_REGION_IDS
, '
, '||TO_CHAR(IO_RULES.REGION_ID)||'
, ' )!= 0 OR IO_RULES.ORDER_TYPE_ID = OE_ITORD_UTIL.GET_ORDER_TYPE_ID OR IO_RULES.SHIP_TO_LOCATION_ID = OE_ITORD_UTIL.GET_SHIP_TO_ORG_ID OR IO_RULES.SALES_CHANNEL_CODE = OE_ITORD_UTIL.GET_SALES_CHANNEL_CODE OR IO_RULES.SALES_PERSON_ID = OE_ITORD_UTIL.GET_SALESREP_ID OR IO_RULES.END_CUSTOMER_ID = OE_ITORD_UTIL.GET_END_CUSTOMER_ID OR IO_RULES.BILL_TO_LOCATION_ID = OE_ITORD_UTIL.GET_INVOICE_TO_ORG_ID OR IO_RULES.DELIVER_TO_LOCATION_ID = OE_ITORD_UTIL.GET_DELIVER_TO_ORG_ID ) )
AND MV.ORGANIZATION_ID = OE_ITORD_UTIL.GET_ITEM_VALIDATION_ORG_ID
AND MV.LANGUAGE = USERENV('LANG')
AND MV.INVENTORY_ITEM_ID = IO_HDR.INVENTORY_ITEM_ID UNION ALL SELECT MV.ITEM
, MV.ITEM_ID
, MV.ITEM_DESCRIPTION
, MV.INVENTORY_ITEM_ID
, MV.INVENTORY_ITEM
, MV.ITEM_IDENTIFIER_TYPE
, MV.SOLD_TO_ORG_ID
, MV.ORGANIZATION_ID
, MV.ITEM_STATUS
, MV.CROSS_REF_STATUS
, MV.ADDRESS
, MV.CUST_ADDRESS
, MV.ITEM_DEFINITION_LEVEL
, MV.RANK
, MV.SITE_USE_ID
, MV.ITEM_DEFINITION_LEVEL_CODE
, MV.LANGUAGE
, MV.CATEGORY_ID
, MV.ORG_INDEPENDENT_FLAG
, MV.CROSS_REF_ORG_ID
FROM OE_ITEMS_MV MV
, OE_ITEM_ORDERABILITY IO_HDR
WHERE IO_HDR.ORG_ID = OE_ITORD_UTIL.GET_OPERATING_UNIT_ID
AND IO_HDR.ITEM_LEVEL = 'C'
AND IO_HDR.GENERALLY_AVAILABLE = 'Y'
AND IO_HDR.ENABLE_FLAG = 'Y'
AND NOT EXISTS ( SELECT 1
FROM OE_ITEM_ORDERABILITY_RULES IO_RULES
WHERE IO_RULES.ORDERABILITY_ID = IO_HDR.ORDERABILITY_ID
AND IO_RULES.ENABLE_FLAG = 'Y'
AND (IO_RULES.CUSTOMER_ID = OE_ITORD_UTIL.GET_CUSTOMER_ID OR IO_RULES.CUSTOMER_CLASS_ID = OE_ITORD_UTIL.GET_CUSTOMER_CLASS_ID OR IO_RULES.CUSTOMER_CATEGORY_CODE = OE_ITORD_UTIL.GET_CUSTOMER_CATEGORY_CODE OR INSTR(OE_ITORD_UTIL.GET_REGION_IDS
, '
, '||TO_CHAR(IO_RULES.REGION_ID)||'
, ' )!= 0 OR IO_RULES.ORDER_TYPE_ID = OE_ITORD_UTIL.GET_ORDER_TYPE_ID OR IO_RULES.SHIP_TO_LOCATION_ID = OE_ITORD_UTIL.GET_SHIP_TO_ORG_ID OR IO_RULES.SALES_CHANNEL_CODE = OE_ITORD_UTIL.GET_SALES_CHANNEL_CODE OR IO_RULES.SALES_PERSON_ID = OE_ITORD_UTIL.GET_SALESREP_ID OR IO_RULES.END_CUSTOMER_ID = OE_ITORD_UTIL.GET_END_CUSTOMER_ID OR IO_RULES.BILL_TO_LOCATION_ID = OE_ITORD_UTIL.GET_INVOICE_TO_ORG_ID OR IO_RULES.DELIVER_TO_LOCATION_ID = OE_ITORD_UTIL.GET_DELIVER_TO_ORG_ID ) )
AND MV.ORGANIZATION_ID = OE_ITORD_UTIL.GET_ITEM_VALIDATION_ORG_ID
AND MV.LANGUAGE = USERENV('LANG')
AND MV.CATEGORY_ID = IO_HDR.ITEM_CATEGORY_ID UNION ALL SELECT MV.ITEM
, MV.ITEM_ID
, MV.ITEM_DESCRIPTION
, MV.INVENTORY_ITEM_ID
, MV.INVENTORY_ITEM
, MV.ITEM_IDENTIFIER_TYPE
, MV.SOLD_TO_ORG_ID
, MV.ORGANIZATION_ID
, MV.ITEM_STATUS
, MV.CROSS_REF_STATUS
, MV.ADDRESS
, MV.CUST_ADDRESS
, MV.ITEM_DEFINITION_LEVEL
, MV.RANK
, MV.SITE_USE_ID
, MV.ITEM_DEFINITION_LEVEL_CODE
, MV.LANGUAGE
, MV.CATEGORY_ID
, MV.ORG_INDEPENDENT_FLAG
, MV.CROSS_REF_ORG_ID
FROM OE_ITEMS_MV MV
WHERE MV.ORGANIZATION_ID = OE_ITORD_UTIL.GET_ITEM_VALIDATION_ORG_ID
AND MV.LANGUAGE = USERENV('LANG')
AND NOT EXISTS ( SELECT 1
FROM OE_ITEM_ORDERABILITY IO_HDR
WHERE IO_HDR.INVENTORY_ITEM_ID = MV.INVENTORY_ITEM_ID
AND IO_HDR.ORG_ID = OE_ITORD_UTIL.GET_OPERATING_UNIT_ID
AND IO_HDR.ITEM_LEVEL = 'I'
AND IO_HDR.ENABLE_FLAG = 'Y' UNION ALL SELECT 1
FROM OE_ITEM_ORDERABILITY IO_HDR
WHERE IO_HDR.ITEM_CATEGORY_ID = MV.CATEGORY_ID
AND IO_HDR.ORG_ID = OE_ITORD_UTIL.GET_OPERATING_UNIT_ID
AND IO_HDR.ITEM_LEVEL = 'C'
AND IO_HDR.ENABLE_FLAG = 'Y' )