DBA Data[Home] [Help]

APPS.OKL_ACTIVATE_ASSET_PVT dependencies on MTL_SYSTEM_ITEMS

Line 1918: FROM MTL_SYSTEM_ITEMS msi,

1914: --Bug Fix # 2887948
1915: --CURSOR to fetch expense account id
1916: CURSOR exp_act_csr (p_kle_id IN NUMBER) IS
1917: SELECT msi.expense_account
1918: FROM MTL_SYSTEM_ITEMS msi,
1919: OKC_K_ITEMS cim,
1920: OKC_K_LINES_B mdl,
1921: OKC_K_LINES_B fal
1922: WHERE cim.object1_id1 = msi.inventory_item_id

Line 2234: --expence ccid will come from mtl_system_items expense ccid

2230:
2231: -- CONFIRM ABOUT EXPENSE CCID
2232: --how to get the expense ccid ??
2233: --l_asset_dist_rec.code_combination_id := ??
2234: --expence ccid will come from mtl_system_items expense ccid
2235: OPEN exp_act_csr (p_kle_id => p_talv_rec.kle_id);
2236: Fetch exp_act_csr into
2237: l_expense_account;
2238: If exp_act_csr%NOTFOUND Then