APPS.OKL_AM_VENDOR_RES_SHARE_PVT dependencies on OKL_PARTY_PAYMENT_DTLS_UV

Line 1798: OKL_PARTY_PAYMENT_DTLS_UV PPD

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'
1802: AND TAL.KLE_ID = CLE.ID

Line 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';

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 ||