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.CST_ACCRUAL_LOAD dependencies on FINANCIALS_SYSTEM_PARAMS_ALL

Line 845: financials_system_params_all fsp

841: SELECT NVL(fc.minimum_accountable_unit,power(10,NVL(-fc.precision,0)))
842: INTO l_round_unit
843: FROM fnd_currencies fc,
844: gl_sets_of_books gsb,
845: financials_system_params_all fsp
846: WHERE fsp.org_id = p_operating_unit
847: AND fsp.set_of_books_id = gsb.set_of_books_id
848: AND fc.currency_code = gsb.currency_code;
849:

Line 1255: financials_system_params_all fsp,

1251: pawo.program_update_date
1252: FROM
1253: po_accrual_write_offs_all pawo,
1254: ap_invoice_distributions_all aida,
1255: financials_system_params_all fsp,
1256: gl_sets_of_books gsob,
1257: fnd_currencies fc,
1258: ap_ae_lines_all aal,
1259: xla_distribution_links xld

Line 1390: financials_system_params_all fsp,

1386: pawo.program_update_date
1387: FROM
1388: po_accrual_write_offs_all pawo,
1389: ap_invoice_distributions_all aida,
1390: financials_system_params_all fsp,
1391: gl_sets_of_books gsob,
1392: fnd_currencies fc,
1393: ap_ae_lines_all aal,
1394: cst_accrual_accounts caa,

Line 1537: financials_system_params_all fsp,

1533: po_distributions_all pod,
1534: po_releases_all pra,
1535: po_headers_all poh,
1536: ap_invoice_distributions_all aida,
1537: financials_system_params_all fsp,
1538: gl_sets_of_books gsob,
1539: fnd_currencies fc,
1540: ap_ae_lines aal,
1541: cst_accrual_accounts caa,

Line 1705: financials_system_params_all fsp,

1701: po_distributions_all pod,
1702: po_releases_all pra,
1703: po_headers_all poh,
1704: ap_invoice_distributions_all aida,
1705: financials_system_params_all fsp,
1706: gl_sets_of_books gsob,
1707: fnd_currencies fc,
1708: ap_ae_lines aal,
1709: cst_accrual_accounts caa,

Line 2150: ,financials_system_params_all fsp --BUG#13869348

2146: ap_ae_lines_all aal,
2147: cst_accrual_accounts ca, --BUG#7528609
2148: xla_distribution_links xld
2149: ,xla_ae_lines xlal --XLD AP <=> n XLA AE line AP with different GL Accounts
2150: ,financials_system_params_all fsp --BUG#13869348
2151: WHERE pawo.org_id = p_operating_unit
2152: AND fsp.org_id = p_operating_unit
2153: AND pawo.transaction_source_code = 'AP'
2154: AND cwo.write_off_id = pawo.write_off_id

Line 2431: financials_system_params_all fsp

2427: FROM xla_ae_headers xah,
2428: xla_ae_lines xal,
2429: xla_distribution_links xdl,
2430: cst_accrual_accounts caa,
2431: financials_system_params_all fsp
2432: WHERE fsp.org_id = p_operating_unit
2433: AND caa.operating_unit_id = p_operating_unit
2434: AND xah.application_id = 200 -- AP
2435: AND xah.accounting_date between p_from_date AND p_to_date

Line 2718: FROM financials_system_params_all fsp

2714: p_to_dt IN DATE)
2715: IS
2716: SELECT
2717: 'Y'
2718: FROM financials_system_params_all fsp
2719: WHERE fsp.org_id = p_ou_id
2720: AND EXISTS(
2721: SELECT 1 FROM
2722: xla_ae_lines l,

Line 2878: financials_system_params_all fsp

2874: xla_ae_lines xal,
2875: xla_transaction_entities_upg xte,
2876: mtl_material_transactions mmt,
2877: cst_accrual_accounts caa,
2878: financials_system_params_all fsp
2879: WHERE xal.code_combination_id = caa.accrual_account_id
2880: AND caa.operating_unit_id = p_operating_unit
2881: AND fsp.org_id = p_operating_unit
2882: AND fsp.set_of_books_id = xah.ledger_id

Line 3014: financials_system_params_all fsp,

3010: xla_ae_lines xal,
3011: xla_transaction_entities_upg xte,
3012: mtl_material_transactions mmt,
3013: cst_accrual_accounts caa,
3014: financials_system_params_all fsp,
3015: mtl_parameters mp /* Bug 13728770 */
3016: WHERE xal.code_combination_id = caa.accrual_account_id
3017: AND caa.operating_unit_id = p_operating_unit
3018: AND fsp.org_id = p_operating_unit

Line 3096: financials_system_params_all fsp,

3092: xla_ae_lines xal,
3093: xla_transaction_entities_upg xte,
3094: mtl_material_transactions mmt,
3095: cst_accrual_accounts caa,
3096: financials_system_params_all fsp,
3097: mtl_parameters mp /* Bug 13728770 */
3098: WHERE xal.code_combination_id = caa.accrual_account_id
3099: AND caa.operating_unit_id = p_operating_unit
3100: AND fsp.org_id = p_operating_unit

Line 3667: financials_system_params_all fsp

3663: po_headers_all poh,
3664: po_lines_all pol,
3665: po_distributions_all pod,
3666: cst_accrual_accounts caa,
3667: financials_system_params_all fsp
3668: WHERE fsp.org_id = p_operating_unit
3669: AND xah.ledger_id = fsp.set_of_books_id
3670: AND xah.application_id = 707
3671: AND xal.application_id = 707

Line 3788: financials_system_params_all fsp

3784: po_headers_all poh,
3785: po_lines_all pol,
3786: po_distributions_all pod,
3787: cst_accrual_accounts caa,
3788: financials_system_params_all fsp
3789: WHERE fsp.org_id = p_operating_unit
3790: AND xah.ledger_id = fsp.set_of_books_id
3791: AND xah.application_id = 555
3792: AND xal.application_id = 555

Line 3952: financials_system_params_all fsp,

3948: xla_distribution_links xdl,
3949: po_lines_all pol,
3950: po_distributions_all pod,
3951: cst_accrual_accounts caa,
3952: financials_system_params_all fsp,
3953: xla_transaction_entities_upg xte,
3954: po_headers_all poh /* -- Changes to pick Vendor from PO instead of APIA. Bug 7312170 */
3955: WHERE xal.code_combination_id = caa.accrual_account_id
3956: AND caa.operating_unit_id = p_operating_unit