APPS.OKL_AM_VENDOR_RES_SHARE_PVT dependencies on OKC_K_HEADERS_B

Line 48: contract_number OKC_K_HEADERS_B.contract_number%TYPE,

44: asset_sts_code OKC_K_LINES_B.sts_code%TYPE,
45: date_terminated DATE,
46: asset_residual OKL_K_LINES.residual_value%TYPE,
47: khr_id NUMBER,
48: contract_number OKC_K_HEADERS_B.contract_number%TYPE,
49: product_id NUMBER,
50: vpa_id NUMBER,
51: vpa_number OKC_K_HEADERS_B.contract_number%TYPE,
52: retirement_id NUMBER,

Line 51: vpa_number OKC_K_HEADERS_B.contract_number%TYPE,

47: khr_id NUMBER,
48: contract_number OKC_K_HEADERS_B.contract_number%TYPE,
49: product_id NUMBER,
50: vpa_id NUMBER,
51: vpa_number OKC_K_HEADERS_B.contract_number%TYPE,
52: retirement_id NUMBER,
53: date_retired DATE,
54: scs_code OKC_K_HEADERS_B.scs_code%TYPE); -- rmunjulu 4622198
55:

Line 54: scs_code OKC_K_HEADERS_B.scs_code%TYPE); -- rmunjulu 4622198

50: vpa_id NUMBER,
51: vpa_number OKC_K_HEADERS_B.contract_number%TYPE,
52: retirement_id NUMBER,
53: date_retired DATE,
54: scs_code OKC_K_HEADERS_B.scs_code%TYPE); -- rmunjulu 4622198
55:
56: TYPE kle_tbl_type IS TABLE OF kle_rec_type INDEX BY BINARY_INTEGER;
57:
58: -- Rec Type to store contract Details

Line 1284: OKC_K_HEADERS_B CHR,

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,
1287: OKC_K_HEADERS_B VPA,
1288: FA_RETIREMENTS RET,

Line 1287: OKC_K_HEADERS_B VPA,

1283: OKL_K_LINES KLE,
1284: OKC_K_HEADERS_B CHR,
1285: OKL_K_HEADERS KHR,
1286: OKC_LINE_STYLES_V LSE,
1287: OKC_K_HEADERS_B VPA,
1288: FA_RETIREMENTS RET,
1289: OKX_ASSET_LINES_V OAL
1290: WHERE CLE.id = KLE.id
1291: AND KHR.id = CHR.id

Line 1793: OKC_K_HEADERS_B CHR,

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,
1797: OKL_TXL_ASSETS_B TAL,

Line 1794: OKC_K_HEADERS_B VPA,

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,
1797: OKL_TXL_ASSETS_B TAL,
1798: OKL_PARTY_PAYMENT_DTLS_UV PPD

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