View: QA_SALES_ORDERS_LOV_V

Product:	QA - Quality
Description:	Sales Order LOV record group
Implementation/DBA Data:	APPS.QA_SALES_ORDERS_LOV_V

View Text

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'))

Columns