View: OKX_COVERED_LINES_V

Product:	OKX - Contracts Integration
Description:
Implementation/DBA Data:	APPS.OKX_COVERED_LINES_V

View Text

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
, 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(TRUNC(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
, SI.SERVICEABLE_PRODUCT_FLAG SERVICEABLE_PRODUCT_FLAG
, NULL PRIMARY_UOM_CODE
, UOM.UNIT_OF_MEASURE_TL UNIT_OF_MEASURE
FROM MTL_UNITS_OF_MEASURE_TL UOM
, JTF_OBJECTS_B JOT
, OKC_K_LINES_B B
, OKC_K_LINES_TL TL
, OKC_K_ITEMS CIM
, OKX_SYSTEM_ITEMS_V SI
WHERE TL.ID = B.ID
AND TL.LANGUAGE = USERENV('LANG')
AND CIM.CLE_ID = B.ID
AND CIM.OBJECT1_ID1 = TO_CHAR( SI.ID1)
AND TO_CHAR( SI.ID2) = CIM.OBJECT1_ID2
AND CIM.JTOT_OBJECT1_CODE = JOT.OBJECT_CODE
AND JOT.FROM_TABLE LIKE 'OKX_SYSTEM_ITEMS_V%'
AND SI.SERVICE_ITEM_FLAG = 'N'
AND UOM.UOM_CODE(+) = CIM.UOM_CODE
AND UOM.LANGUAGE = USERENV('LANG')

Columns