eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: APPS.OKL_POOL_TRANS_CONTENTS_UV

Source

View Text - Preformatted


SELECT pocb.id poc_id , pocb.pol_id , pocb.transaction_number_in transaction_number_in, pocb.transaction_number_out transaction_number_out, pocb.status_code, chrb.id dnz_chr_id, chrb.contract_number contract_number, pocb.kle_id kle_id , clet.name asset_number , hzpb.party_name lessee, styv.id sty_id , styv.name stream_type_name , styv.stream_type_subclass sty_subclass_code, fnds.meaning sty_subclass, pocb.streams_from_date streams_from_date, pocb.streams_to_date streams_to_date , pocb.stm_id stm_id, styv.stream_type_purpose sty_purpose_code, fndt.meaning stream_type_purpose FROM OKL_POOL_CONTENTS POCB,OKC_K_HEADERS_B CHRB,OKC_K_PARTY_ROLES_B CPLB,HZ_PARTIES HZPB,OKC_K_LINES_TL CLET,OKL_STRM_TYPE_V STYV,FND_LOOKUPS FNDS,FND_LOOKUPS FNDT WHERE pocb.khr_id = chrb.id AND cplb.dnz_chr_id = chrb.id AND cplb.object1_id1 = hzpb.party_id AND cplb.object1_id2 = '#' AND cplb.rle_code = 'LESSEE' AND pocb.kle_id = clet.id AND clet.LANGUAGE = USERENV('LANG') AND styv.id = pocb.sty_id AND fnds.lookup_type = 'OKL_STREAM_TYPE_SUBCLASS' AND fnds.lookup_code = styv.stream_type_subclass AND fndt.lookup_type = 'OKL_STREAM_TYPE_PURPOSE' AND fndt.lookup_code = styv.stream_type_purpose

View Text - HTML Formatted

SELECT POCB.ID POC_ID
, POCB.POL_ID
, POCB.TRANSACTION_NUMBER_IN TRANSACTION_NUMBER_IN
, POCB.TRANSACTION_NUMBER_OUT TRANSACTION_NUMBER_OUT
, POCB.STATUS_CODE
, CHRB.ID DNZ_CHR_ID
, CHRB.CONTRACT_NUMBER CONTRACT_NUMBER
, POCB.KLE_ID KLE_ID
, CLET.NAME ASSET_NUMBER
, HZPB.PARTY_NAME LESSEE
, STYV.ID STY_ID
, STYV.NAME STREAM_TYPE_NAME
, STYV.STREAM_TYPE_SUBCLASS STY_SUBCLASS_CODE
, FNDS.MEANING STY_SUBCLASS
, POCB.STREAMS_FROM_DATE STREAMS_FROM_DATE
, POCB.STREAMS_TO_DATE STREAMS_TO_DATE
, POCB.STM_ID STM_ID
, STYV.STREAM_TYPE_PURPOSE STY_PURPOSE_CODE
, FNDT.MEANING STREAM_TYPE_PURPOSE
FROM OKL_POOL_CONTENTS POCB
, OKC_K_HEADERS_B CHRB
, OKC_K_PARTY_ROLES_B CPLB
, HZ_PARTIES HZPB
, OKC_K_LINES_TL CLET
, OKL_STRM_TYPE_V STYV
, FND_LOOKUPS FNDS
, FND_LOOKUPS FNDT
WHERE POCB.KHR_ID = CHRB.ID
AND CPLB.DNZ_CHR_ID = CHRB.ID
AND CPLB.OBJECT1_ID1 = HZPB.PARTY_ID
AND CPLB.OBJECT1_ID2 = '#'
AND CPLB.RLE_CODE = 'LESSEE'
AND POCB.KLE_ID = CLET.ID
AND CLET.LANGUAGE = USERENV('LANG')
AND STYV.ID = POCB.STY_ID
AND FNDS.LOOKUP_TYPE = 'OKL_STREAM_TYPE_SUBCLASS'
AND FNDS.LOOKUP_CODE = STYV.STREAM_TYPE_SUBCLASS
AND FNDT.LOOKUP_TYPE = 'OKL_STREAM_TYPE_PURPOSE'
AND FNDT.LOOKUP_CODE = STYV.STREAM_TYPE_PURPOSE