VIEW: APPS.OKL_LA_ITEM_DTLS_UV

Source

View Text - Preformatted

SELECT cle.id ID , cle.cle_id PARENT_LINE_ID , to_char(cle.price_unit) UNIT_COST , cle.dnz_chr_id dnz_chr_id , 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 , KLE.MANUFACTURER_NAME MANUFACTURER_NAME , KLE.MODEL_NUMBER MODEL_NUMBER , KLE.YEAR_OF_MANUFACTURE YEAR_OF_MANUFACTURE , to_char(null) VENDOR_NAME , cpl.object1_id1 VENDOR_ID , cpl.id CPL_ID , CTLE.COMMENTS COMMENTS FROM OKL_K_LINES KLE,OKC_K_LINES_B CLE,OKC_K_LINES_TL CTLE,OKC_K_ITEMS CIM,OKC_LINE_STYLES_B LSE,MTL_SYSTEM_ITEMS_B MTLB,MTL_SYSTEM_ITEMS_TL MTLT,OKC_K_PARTY_ROLES_B CPL WHERE cle.id = kle.id and cle.id = ctle.id and ctle.language = userenv('lang') and kle.id = ctle.id and cle.dnz_chr_id = cpl.dnz_chr_id(+) and cpl.cle_id(+) = cle.id and cpl.rle_code(+) = 'OKL_VENDOR' and cpl.chr_id is null 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
, CLE.DNZ_CHR_ID DNZ_CHR_ID
, 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
, KLE.MANUFACTURER_NAME MANUFACTURER_NAME
, KLE.MODEL_NUMBER MODEL_NUMBER
, KLE.YEAR_OF_MANUFACTURE YEAR_OF_MANUFACTURE
, TO_CHAR(NULL) VENDOR_NAME
, CPL.OBJECT1_ID1 VENDOR_ID
, CPL.ID CPL_ID
, CTLE.COMMENTS COMMENTS
FROM OKL_K_LINES KLE
, OKC_K_LINES_B CLE
, OKC_K_LINES_TL CTLE
, OKC_K_ITEMS CIM
, OKC_LINE_STYLES_B LSE
, MTL_SYSTEM_ITEMS_B MTLB
, MTL_SYSTEM_ITEMS_TL MTLT
, OKC_K_PARTY_ROLES_B CPL
WHERE CLE.ID = KLE.ID
AND CLE.ID = CTLE.ID
AND CTLE.LANGUAGE = USERENV('LANG')
AND KLE.ID = CTLE.ID
AND CLE.DNZ_CHR_ID = CPL.DNZ_CHR_ID(+)
AND CPL.CLE_ID(+) = CLE.ID
AND CPL.RLE_CODE(+) = 'OKL_VENDOR'
AND CPL.CHR_ID IS NULL
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')