eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

View: XNC_PROV_V

Product:	XNC - Sales for Communications (Obsolete)
Description:	XNC_PROV_V retrieves provisioning data applied to an order line.
Implementation/DBA Data:	Not implemented in this database

View Text

SELECT DISTINCT AOL.LINE_ID
, XPV.ORGANIZATION_ID
, C.ATTRIBUTE_ID CP_PARAMETER_ID
, C.ATTRIBUTE_NAME NAME
, A.ATTRIBUTE_VALUE VALUE
, XPV.PARAMETER_MEANING
, DECODE(XPV.SYSTEM_DEFINED_FLAG
, 'Y'
, LKPE.MEANING
, LKPC.MEANING) SOURCE
FROM CSI_I_EXTENDED_ATTRIBS C
, CSI_IEA_VALUES A
, XNC_ITEM_ACTIONS_V XAV
, XNC_ITEM_ACTION_PARS_V XPV
, ASO_I_OE_ORDER_LINES_V AOL
, FND_LOOKUP_VALUES_VL LKPE
, FND_LOOKUP_VALUES_VL LKPC
, CSI_ITEM_INSTANCES CSI
WHERE C.ATTRIBUTE_ID = A.ATTRIBUTE_ID
AND C.ATTRIBUTE_CODE = XPV.PARAMETER_NAME
AND AOL.INVENTORY_ITEM_ID = C.INVENTORY_ITEM_ID
AND A.INSTANCE_ID =CSI.INSTANCE_ID
AND XAV.ITEM_ACTION_ID = XPV.ITEM_ACTION_ID
AND AOL.INVENTORY_ITEM_ID = XAV.INVENTORY_ITEM_ID
AND AOL.SHIP_FROM_ORG_ID = XAV.ORGANIZATION_ID
AND NVL(A.ACTIVE_END_DATE
, SYSDATE) >= SYSDATE
AND AOL.LINE_ID = CSI.LAST_OE_ORDER_LINE_ID
AND LKPC.VIEW_APPLICATION_ID = 532
AND LKPC.LOOKUP_TYPE = 'XNC_ACTION_PAR_VALUE_SOURCE'
AND LKPC.LOOKUP_CODE = 'CUSTOMER'
AND LKPE.VIEW_APPLICATION_ID = 532
AND LKPE.LOOKUP_TYPE = 'XNC_ACTION_PAR_VALUE_SOURCE'
AND LKPE.LOOKUP_CODE = 'EXTERNAL'

Columns

Name
LINE_ID
ORGANIZATION_ID
CP_PARAMETER_ID
NAME
VALUE
PARAMETER_MEANING
SOURCE