Skip to content FND Design Data [Home] [Help]

View: XNC_ORDER_LINE_SUBSCRIPTION_V

Product: XNC - Sales for Communications (Obsolete)
Description: This view gives subscription for a given Order Line.
Implementation/DBA Data: Not implemented in this database
View Text

SELECT UNIQUE OL.HEADER_ID
, OL.LINE_ID
, OL.ORG_ID
, OL.INVENTORY_ITEM_ID
, CT.NAME SUBSCRIPTION
FROM CSI_T_TXN_LINE_DETAILS A
, CSI_T_TRANSACTION_LINES B
, CSI_SYSTEMS_B CSS
, CSI_SYSTEMS_TL CT
, OE_ORDER_LINES_ALL OL
WHERE OL.LINE_ID = B.SOURCE_TRANSACTION_ID
AND B.TRANSACTION_LINE_ID = A.TRANSACTION_LINE_ID
AND CSS.SYSTEM_ID(+) = A.CSI_SYSTEM_ID
AND CSS.SYSTEM_ID = CT.SYSTEM_ID (+)
AND CT.LANGUAGE (+)= USERENV('LANG')

Columns

Name
HEADER_ID
LINE_ID
ORG_ID
INVENTORY_ITEM_ID
SUBSCRIPTION