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_AR_RBD_EXPORT_PKG dependencies on JA_CN_LEDGER_LE_BSV_GT

Line 1278: FROM ja_cn_ledger_le_bsv_gt llbg

1274: AND Jcc.Ledger_id = Aeh.Ledger_id
1275: AND Jcc.Code_Combination_Id = Ael.Code_Combination_Id
1276: --BSV condition, to handle one invoice having BSVs from different legal entity in distribution lines
1277: AND EXISTS (SELECT llbg.Bal_Seg_Value
1278: FROM ja_cn_ledger_le_bsv_gt llbg
1279: WHERE JA_CN_CFS_DATA_CLT_PKG.get_balancing_segment(Ael.CODE_COMBINATION_ID) = llbg.Bal_Seg_Value
1280: AND llbg.Ledger_Id = pn_ledger_id --parameter: pn_ledger_id
1281: AND llbg.Legal_Entity_Id = pn_legal_entity_id) --parameter: pn_legal_entity_id
1282: )

Line 1484: FROM ja_cn_ledger_le_bsv_gt llbg

1480: AND jeh.status = 'P' -- AR posted to GL
1481: AND ael.accounting_class_code = 'RECEIVABLE'--accountingclass is 'Receivable' in the accounting line in SLA
1482: --BSV Condition
1483: AND EXISTS (SELECT llbg.Bal_Seg_Value
1484: FROM ja_cn_ledger_le_bsv_gt llbg
1485: WHERE JA_CN_CFS_DATA_CLT_PKG.get_balancing_segment(Jcc.CODE_COMBINATION_ID) = llbg.Bal_Seg_Value
1486: AND llbg.Ledger_Id = pn_ledger_id --parameter: pn_ledger_id
1487: AND llbg.Legal_Entity_Id = pn_legal_entity_id) --parameter: pn_legal_entity_id
1488: --Period condition

Line 1722: FROM ja_cn_ledger_le_bsv_gt llbg

1718: AND jeh.status = 'P' -- AR posted to GL
1719: AND ael.accounting_class_code = 'RECEIVABLE'--accountingclass is 'Receivable' in the accounting line in SLA
1720: --BSV Condition
1721: AND EXISTS (SELECT llbg.Bal_Seg_Value
1722: FROM ja_cn_ledger_le_bsv_gt llbg
1723: WHERE JA_CN_CFS_DATA_CLT_PKG.get_balancing_segment(Jcc.CODE_COMBINATION_ID) = llbg.Bal_Seg_Value
1724: AND llbg.Ledger_Id = pn_ledger_id --parameter: pn_ledger_id
1725: AND llbg.Legal_Entity_Id = pn_legal_entity_id) --parameter: pn_legal_entity_id
1726: --ld_start_date and ld_end_date come from pv_accounting_year, pv_period_from, pv_period_to

Line 2318: FROM ja_cn_ledger_le_bsv_gt llbg

2314: AND Ael.Accounting_Class_Code = 'RECEIVABLE'
2315: AND Aeh.Ae_Header_Id = ln_ae_header_id --variable: ln_ae_header_id
2316: --BSV condition, one transaction having BSVs with different legal entity in distribution lines????
2317: AND EXISTS (SELECT llbg.Bal_Seg_Value
2318: FROM ja_cn_ledger_le_bsv_gt llbg
2319: WHERE JA_CN_CFS_DATA_CLT_PKG.get_balancing_segment(Ael.CODE_COMBINATION_ID) = llbg.Bal_Seg_Value
2320: AND llbg.Ledger_Id = pn_ledger_id --parameter: pn_ledger_id
2321: AND llbg.Legal_Entity_Id = pn_legal_entity_id); --parameter: pn_legal_entity_id
2322:

Line 2353: FROM ja_cn_ledger_le_bsv_gt llbg

2349: AND App.applied_customer_trx_id = ln_customer_trx_id
2350: )
2351: --BSV condition, one transaction having BSVs with different legal entity in distribution lines
2352: AND EXISTS (SELECT llbg.Bal_Seg_Value
2353: FROM ja_cn_ledger_le_bsv_gt llbg
2354: WHERE JA_CN_CFS_DATA_CLT_PKG.get_balancing_segment(Ael.CODE_COMBINATION_ID) = llbg.Bal_Seg_Value
2355: AND llbg.Ledger_Id = pn_ledger_id --parameter: pn_ledger_id
2356: AND llbg.Legal_Entity_Id = pn_legal_entity_id); --parameter: pn_legal_entity_i
2357:

Line 2373: FROM ja_cn_ledger_le_bsv_gt llbg

2369: AND Aeh.Ae_Header_Id = ln_ae_header_id --variable: ln_ae_header_id
2370: AND Ael.Ae_Line_Num = ln_ae_line_num
2371: --BSV condition, one transaction having BSVs with different legal entity in distribution lines????
2372: AND EXISTS (SELECT llbg.Bal_Seg_Value
2373: FROM ja_cn_ledger_le_bsv_gt llbg
2374: WHERE JA_CN_CFS_DATA_CLT_PKG.get_balancing_segment(Ael.CODE_COMBINATION_ID) = llbg.Bal_Seg_Value
2375: AND llbg.Ledger_Id = pn_ledger_id --parameter: pn_ledger_id
2376: AND llbg.Legal_Entity_Id = pn_legal_entity_id); --parameter: pn_legal_entity_id
2377:

Line 2479: --1. Populate balancing segment values to table ja_cn_ledger_le_bsv_gt

2475: 'pn_coa_id=' || pn_coa_id || ',' ||
2476: 'pv_period_from=' || pv_period_from || ',' ||
2477: 'pv_period_to=' || pv_period_to);*/
2478:
2479: --1. Populate balancing segment values to table ja_cn_ledger_le_bsv_gt
2480: /*DELETE FROM JA_CN_LEDGER_LE_BSV_GT;
2481: COMMIT;
2482: IF Ja_Cn_Utility.Populate_Ledger_Le_Bsv_Gt(pn_Ledger_Id,pn_legal_entity_id) <> 'S'
2483: THEN

Line 2480: /*DELETE FROM JA_CN_LEDGER_LE_BSV_GT;

2476: 'pv_period_from=' || pv_period_from || ',' ||
2477: 'pv_period_to=' || pv_period_to);*/
2478:
2479: --1. Populate balancing segment values to table ja_cn_ledger_le_bsv_gt
2480: /*DELETE FROM JA_CN_LEDGER_LE_BSV_GT;
2481: COMMIT;
2482: IF Ja_Cn_Utility.Populate_Ledger_Le_Bsv_Gt(pn_Ledger_Id,pn_legal_entity_id) <> 'S'
2483: THEN
2484: RETURN;