This view gives parameters name and value for a given Order Line.
Implementation/DBA Data:
Not implemented in this database
View Text
SELECT DISTINCT AOL.LINE_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_T_TXN_LINE_DETAILS E , CSI_T_TRANSACTION_LINES D , CSI_I_EXTENDED_ATTRIBS C , CSI_T_EXTEND_ATTRIBS A , CSI_IEA_VALUES F , 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 WHERE AOL.LINE_ID = D.SOURCE_TRANSACTION_ID AND D.TRANSACTION_LINE_ID = E.TRANSACTION_LINE_ID AND AOL.INVENTORY_ITEM_ID = C.INVENTORY_ITEM_ID AND ((C.ATTRIBUTE_ID = A.ATTRIB_SOURCE_ID) OR (A.ATTRIB_SOURCE_ID = F.ATTRIBUTE_VALUE_ID)) AND A.TXN_LINE_DETAIL_ID = E.TXN_LINE_DETAIL_ID AND C.ATTRIBUTE_CODE = XPV.PARAMETER_NAME AND XPV.ITEM_ACTION_ID = XAV.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 LKPC.VIEW_APPLICATION_ID = 532 AND AOL.LINE_ID =49335 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'
[Home] [Help]