VIEW: APPS.QA_SALES_ORDERS_LOV_V

Source

View Text - Preformatted

SELECT mso.segment1 order_number, mso.sales_order_id, mso.segment2 order_type, mso.segment3 order_source, rc.customer_name, oe.cancelled_flag, oe.open_flag, oe.booked_flag, oe.order_category_code FROM mtl_sales_orders mso, oe_order_headers_all oe, qa_customers_lov_v rc, oe_transaction_types_tl ot, fnd_languages fl WHERE mso.segment1 = oe.order_number AND oe.order_type_id = ot.transaction_type_id AND ot.language = fl.language_code AND fl.installed_flag = 'B' AND oe.sold_to_org_id = rc.customer_id (+) AND mso.segment2 = ot.name AND mso.segment3 = fnd_profile.value('ONT_SOURCE_CODE') AND oe.order_category_code in ('MIXED','ORDER') UNION ALL SELECT mso.segment1 order_number, mso.sales_order_id, mso.segment2 order_type, mso.segment3 order_source, null customer_name, null cancelled_flag, null open_flag, null booked_flag, null order_category_code FROM mtl_sales_orders mso WHERE (mso.segment3 <> fnd_profile.value('ONT_SOURCE_CODE'))

View Text - HTML Formatted

SELECT MSO.SEGMENT1 ORDER_NUMBER
, MSO.SALES_ORDER_ID
, MSO.SEGMENT2 ORDER_TYPE
, MSO.SEGMENT3 ORDER_SOURCE
, RC.CUSTOMER_NAME
, OE.CANCELLED_FLAG
, OE.OPEN_FLAG
, OE.BOOKED_FLAG
, OE.ORDER_CATEGORY_CODE
FROM MTL_SALES_ORDERS MSO
, OE_ORDER_HEADERS_ALL OE
, QA_CUSTOMERS_LOV_V RC
, OE_TRANSACTION_TYPES_TL OT
, FND_LANGUAGES FL
WHERE MSO.SEGMENT1 = OE.ORDER_NUMBER
AND OE.ORDER_TYPE_ID = OT.TRANSACTION_TYPE_ID
AND OT.LANGUAGE = FL.LANGUAGE_CODE
AND FL.INSTALLED_FLAG = 'B'
AND OE.SOLD_TO_ORG_ID = RC.CUSTOMER_ID (+)
AND MSO.SEGMENT2 = OT.NAME
AND MSO.SEGMENT3 = FND_PROFILE.VALUE('ONT_SOURCE_CODE')
AND OE.ORDER_CATEGORY_CODE IN ('MIXED'
, 'ORDER') UNION ALL SELECT MSO.SEGMENT1 ORDER_NUMBER
, MSO.SALES_ORDER_ID
, MSO.SEGMENT2 ORDER_TYPE
, MSO.SEGMENT3 ORDER_SOURCE
, NULL CUSTOMER_NAME
, NULL CANCELLED_FLAG
, NULL OPEN_FLAG
, NULL BOOKED_FLAG
, NULL ORDER_CATEGORY_CODE
FROM MTL_SALES_ORDERS MSO
WHERE (MSO.SEGMENT3 <> FND_PROFILE.VALUE('ONT_SOURCE_CODE'))