[Home] [Help]
1278: KHR.pdt_id,
1279: RET.retirement_id,
1280: RET.date_retired,
1281: CHR.scs_code -- rmunjulu 4622198
1282: FROM OKC_K_LINES_V CLE,
1283: OKL_K_LINES KLE,
1284: OKC_K_HEADERS_B CHR,
1285: OKL_K_HEADERS KHR,
1286: OKC_LINE_STYLES_V LSE,
1788: PPD.vendor_name VENDOR,
1789: TAL.fa_trx_date DISPOSITION_DATE,
1790: --VPA.contract_number ||' '|| CHR.currency_code VENDOR_SHARE
1791: TAL.residual_shr_amount ||' '|| CHR.currency_code VENDOR_SHARE
1792: FROM OKC_K_LINES_V CLE,
1793: OKC_K_HEADERS_B CHR,
1794: OKC_K_HEADERS_B VPA,
1795: OKL_K_HEADERS KHR,
1796: OKL_TRX_ASSETS TAS,
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 ||