eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.JA_CN_AP_PBD_EXPORT_PKG dependencies on JA_CN_ACCOUNT_BALANCES

Line 1140: FROM ja_cn_account_balances_v jcab

1136: --Cursor for fetching balance at itemization level
1137: CURSOR balance_cur IS
1138: SELECT SUM(func_end_balance) Functional_Balance,
1139: SUM(orig_end_balance) Entered_Balance
1140: FROM ja_cn_account_balances_v jcab
1141: WHERE jcab.ledger_id = pn_ledger_id --parameter: pn_ledger_id
1142: AND jcab.legal_entity_id = pn_legal_entity_id --parameter: pn_legal_entity_id
1143: AND jcab.third_party_id = pn_supplier_id --parameter: pn_supplier_id
1144: AND jcab.account_segment = pv_account_number --parameter: pv_account_number

Line 1220: FROM ja_cn_account_balances jcab

1216: SELECT SUM(NVL(jcab.func_period_net_dr, 0) +
1217: -1 * NVL(jcab.func_period_net_cr, 0)) Functional_Balance,
1218: SUM(NVL(jcab.orig_period_net_dr, 0) +
1219: -1 * NVL(jcab.orig_period_net_cr, 0)) Entered_Balance
1220: FROM ja_cn_account_balances jcab
1221: WHERE jcab.ledger_id = pn_ledger_id --parameter: pn_ledger_id
1222: AND jcab.legal_entity_id = pn_legal_entity_id --parameter: pn_legal_entity_id
1223: AND jcab.third_party_id = pn_supplier_id --parameter: pn_supplier_id
1224: AND jcab.account_segment = pv_account_number --parameter: pv_account_number

Line 2038: Ja_Cn_Account_Balances Jab

2034: FROM (SELECT Jab.Account_Segment Account_Number
2035: FROM Xla_Ae_Headers Aeh,
2036: Xla_Ae_Lines Ael,
2037: Ja_Cn_Code_Combination_v Jcc,
2038: Ja_Cn_Account_Balances Jab
2039: WHERE Jab.Ledger_Id = pn_ledger_id --parameter: pn_ledger_id
2040: AND Jab.Legal_Entity_Id = pn_legal_entity_id --parameter: pn_legal_entity_id
2041: AND Jab.Period_Name = pv_first_period --parameter: pv_first_period
2042: AND Jab.Account_Segment = Jcc.Account_Segment

Line 2218: FROM ja_cn_account_balances

2214: NVL(Func_Begin_Balance_Dr, 0)),
2215: 'PREPAID_EXPENSE',
2216: SUM(NVL(Func_Begin_Balance_Dr, 0) -
2217: NVL(Func_Begin_Balance_Cr, 0))) Functional_Amount
2218: FROM ja_cn_account_balances
2219: WHERE ledger_id = pn_ledger_id --parameter: pn_ledger_id
2220: AND legal_entity_id = pn_legal_entity_id --parameter: pn_legal_entity_id
2221: AND third_party_id = ln_supplier_id --variable: ln_supplier_id
2222: AND account_segment = lv_account_number --variable: lv_account_number

Line 2233: FROM ja_cn_account_balances

2229:
2230: --collecting all supplier id and customer id from account balance table
2231: CURSOR supplier_id_list_cur IS
2232: SELECT DISTINCT Third_Party_Id Supplier_Id
2233: FROM ja_cn_account_balances
2234: WHERE ledger_id = pn_ledger_id --parameter: pn_ledger_id
2235: AND legal_entity_id = pn_legal_entity_id --parameter: pn_legal_entity_id
2236: AND period_name = pv_first_period --parameter: pv_first_period
2237: AND Third_Party_Id IS NOT NULL