VIEW: APPS.OKL_LA_ADD_ITEMS_UV

Source

View Text - Preformatted

SELECT cle.id ID, cle.cle_id PARENT_LINE_ID, to_char(cle.price_unit) UNIT_COST, cim.object1_id1 ID1, cim.object1_id2 ID2, cim.jtot_object1_code OBJECT_CODE, cim.number_of_items QUANTITY, mtlt.description NAME, mtlb.description DESCRIPTION FROM OKL_K_LINES KLE,OKC_K_LINES_B CLE,OKC_K_ITEMS CIM,OKC_LINE_STYLES_B LSE,MTL_SYSTEM_ITEMS_B MTLB,MTL_SYSTEM_ITEMS_TL MTLT WHERE cle.id = kle.id and cle.id = cim.cle_id and cle.lse_id = lse.id and lse.lty_code = 'ADD_ITEM' and cim.dnz_chr_id = cle.dnz_chr_id and cim.object1_id1 = mtlb.inventory_item_id and cim.object1_id2 = to_char(mtlb.organization_id) and cim.jtot_object1_code = 'OKX_SYSITEM' and mtlb.inventory_item_id = mtlt.inventory_item_id and mtlb.organization_id = mtlt.organization_id and mtlt.language = userenv('lang')

View Text - HTML Formatted

SELECT CLE.ID ID
, CLE.CLE_ID PARENT_LINE_ID
, TO_CHAR(CLE.PRICE_UNIT) UNIT_COST
, CIM.OBJECT1_ID1 ID1
, CIM.OBJECT1_ID2 ID2
, CIM.JTOT_OBJECT1_CODE OBJECT_CODE
, CIM.NUMBER_OF_ITEMS QUANTITY
, MTLT.DESCRIPTION NAME
, MTLB.DESCRIPTION DESCRIPTION
FROM OKL_K_LINES KLE
, OKC_K_LINES_B CLE
, OKC_K_ITEMS CIM
, OKC_LINE_STYLES_B LSE
, MTL_SYSTEM_ITEMS_B MTLB
, MTL_SYSTEM_ITEMS_TL MTLT
WHERE CLE.ID = KLE.ID
AND CLE.ID = CIM.CLE_ID
AND CLE.LSE_ID = LSE.ID
AND LSE.LTY_CODE = 'ADD_ITEM'
AND CIM.DNZ_CHR_ID = CLE.DNZ_CHR_ID
AND CIM.OBJECT1_ID1 = MTLB.INVENTORY_ITEM_ID
AND CIM.OBJECT1_ID2 = TO_CHAR(MTLB.ORGANIZATION_ID)
AND CIM.JTOT_OBJECT1_CODE = 'OKX_SYSITEM'
AND MTLB.INVENTORY_ITEM_ID = MTLT.INVENTORY_ITEM_ID
AND MTLB.ORGANIZATION_ID = MTLT.ORGANIZATION_ID
AND MTLT.LANGUAGE = USERENV('LANG')