VIEW: APPS.OKX_PRODUCT_LINES_V

Source

View Text - Preformatted

SELECT B.ID ID1, '#' ID2, NVL(TL.NAME, SI.NAME) NAME, B.LINE_NUMBER DESCRIPTION, TL.ITEM_DESCRIPTION ITEM_DESCRIPTION, TL.COMMENTS COMMENTS, B.CHR_ID CHR_ID, B.DNZ_CHR_ID DNZ_CHR_ID, LS.LTY_CODE LTY_CODE, LS.LSE_TYPE LSE_TYPE, LS.LSE_PARENT_ID LSE_PARENT_ID, B.LINE_NUMBER LINE_NUMBER, B.DATE_TERMINATED DATE_TERMINATED, B.START_DATE START_DATE_ACTIVE, B.END_DATE END_DATE_ACTIVE, DECODE(SIGN(trunc(sysdate)-NVL(b.start_date,trunc(sysdate))),-1,'I', DECODE(SIGN(trunc(sysdate) - NVL(b.end_date,trunc(sysdate))), 1,'I','A')) STATUS, CIM.OBJECT1_ID1 INVENTORY_ITEM_ID, DECODE(CIM.OBJECT1_ID2, '#', -99, CIM.OBJECT1_ID2) ORGANIZATION_ID, CIM.NUMBER_OF_ITEMS QUANTITY, CIM.UOM_CODE UNIT_OF_MEASURE_CODE, SI.NAME ITEM_NAME, NULL PRIMARY_UOM_CODE FROM OKX_SYSTEM_ITEMS_V SI,OKC_K_LINES_B B,OKC_K_LINES_TL TL,OKC_LINE_STYLES_B LS,OKC_K_ITEMS CIM WHERE TL.ID = B.ID AND TL.LANGUAGE = USERENV('LANG') AND LS.ID = B.LSE_ID AND CIM.CLE_ID = B.ID AND CIM.JTOT_OBJECT1_CODE = 'OKX_LICPROD' AND SI.ID1 = CIM.OBJECT1_ID1 AND SI.ID2 = CIM.OBJECT1_ID2

View Text - HTML Formatted

SELECT B.ID ID1
, '#' ID2
, NVL(TL.NAME
, SI.NAME) NAME
, B.LINE_NUMBER DESCRIPTION
, TL.ITEM_DESCRIPTION ITEM_DESCRIPTION
, TL.COMMENTS COMMENTS
, B.CHR_ID CHR_ID
, B.DNZ_CHR_ID DNZ_CHR_ID
, LS.LTY_CODE LTY_CODE
, LS.LSE_TYPE LSE_TYPE
, LS.LSE_PARENT_ID LSE_PARENT_ID
, B.LINE_NUMBER LINE_NUMBER
, B.DATE_TERMINATED DATE_TERMINATED
, B.START_DATE START_DATE_ACTIVE
, B.END_DATE END_DATE_ACTIVE
, DECODE(SIGN(TRUNC(SYSDATE)-NVL(B.START_DATE
, TRUNC(SYSDATE)))
, -1
, 'I'
, DECODE(SIGN(TRUNC(SYSDATE) - NVL(B.END_DATE
, TRUNC(SYSDATE)))
, 1
, 'I'
, 'A')) STATUS
, CIM.OBJECT1_ID1 INVENTORY_ITEM_ID
, DECODE(CIM.OBJECT1_ID2
, '#'
, -99
, CIM.OBJECT1_ID2) ORGANIZATION_ID
, CIM.NUMBER_OF_ITEMS QUANTITY
, CIM.UOM_CODE UNIT_OF_MEASURE_CODE
, SI.NAME ITEM_NAME
, NULL PRIMARY_UOM_CODE
FROM OKX_SYSTEM_ITEMS_V SI
, OKC_K_LINES_B B
, OKC_K_LINES_TL TL
, OKC_LINE_STYLES_B LS
, OKC_K_ITEMS CIM
WHERE TL.ID = B.ID
AND TL.LANGUAGE = USERENV('LANG')
AND LS.ID = B.LSE_ID
AND CIM.CLE_ID = B.ID
AND CIM.JTOT_OBJECT1_CODE = 'OKX_LICPROD'
AND SI.ID1 = CIM.OBJECT1_ID1
AND SI.ID2 = CIM.OBJECT1_ID2