[Home] [Help]
1306: -- Asset is not Securitized is checked once the asset is obtained
1307: AND CLE.id NOT IN (-- residual share already done for that retirement transaction
1308: SELECT TAL.kle_id
1309: FROM OKL_TRX_ASSETS TAS,
1310: OKL_TXL_ASSETS_B TAL
1311: WHERE TAL.kle_id = CLE.id
1312: AND TAL.tas_id = TAS.id
1313: AND TAS.tas_type = 'VRS'
1314: AND TAL.tal_type = 'VRS'
1793: OKC_K_HEADERS_B CHR,
1794: OKC_K_HEADERS_B VPA,
1795: OKL_K_HEADERS KHR,
1796: OKL_TRX_ASSETS TAS,
1797: OKL_TXL_ASSETS_B TAL,
1798: OKL_PARTY_PAYMENT_DTLS_UV PPD
1799: WHERE TAL.TAS_ID = TAS.ID
1800: AND TAS.TAS_TYPE = 'VRS'
1801: AND TAL.TAL_TYPE = 'VRS'
1867: l_api_version := TO_NUMBER(p_api_version);
1868:
1869: l_select_sql_1 := ' SELECT VPA.contract_number PROGRAM_AGREEMENT,CLE.name ASSET_NUMBER,CLE.item_description ASSET_DESCRIPTION,CHR.contract_number CONTRACT_NUMBER, ';
1870: l_select_sql_2 := ' CLE.date_terminated ASSET_TERMINATION_DATE,PPD.vendor_name VENDOR, TAL.fa_trx_date, TAL.residual_shr_amount ||' || ''' ''' || '|| TAL.currency_code VENDOR_SHARE';
1871: l_from_sql_1 := ' FROM OKC_K_LINES_V CLE,OKC_K_HEADERS_B CHR,OKC_K_HEADERS_B VPA,OKL_K_HEADERS KHR,OKL_TRX_ASSETS TAS,OKL_TXL_ASSETS_B TAL,OKL_PARTY_PAYMENT_DTLS_UV PPD';
1872: l_where_sql_1 := ' WHERE TAL.TAS_ID = TAS.ID AND TAS.TAS_TYPE = '||'''VRS'''||' AND TAL.TAL_TYPE = '||'''VRS'''||' ';
1873: l_where_sql_2 := ' AND TAL.KLE_ID = CLE.ID AND CLE.CHR_ID = CHR.ID AND CHR.ID = KHR.ID AND KHR.KHR_ID = VPA.ID AND PPD.CPL_ID = TAL.RESIDUAL_SHR_PARTY_ID ';
1874:
1875: l_total_sql := l_select_sql_1 || l_select_sql_2 ||