APPS.CST_ACCRUAL_LOAD dependencies on XLA_AE_LINES

Line 1543: xla_ae_lines xal

1539: fnd_currencies fc,
1540: ap_ae_lines aal,
1541: cst_accrual_accounts caa,
1542: xla_distribution_links xld,
1543: xla_ae_lines xal
1544: WHERE pawo.org_id = p_operating_unit
1545: AND pawo.po_distribution_id IS NOT NULL -- Reg Invoices and consigned
1546: AND pod.po_distribution_id = pawo.po_distribution_id
1547: AND pra.po_release_id(+) = pod.po_release_id

Line 2149: ,xla_ae_lines xlal --XLD AP <=> n XLA AE line AP with different GL Accounts

2145: ap_invoice_distributions_all aida,
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'

Line 2428: xla_ae_lines xal,

2424: xal.ae_header_id,
2425: xal.ae_line_num,
2426: xdl.source_distribution_id_num_1
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

Line 2722: xla_ae_lines l,

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,
2723: xla_ae_headers h,
2724: xla_event_types_b xet,
2725: cst_accrual_accounts caa
2726: WHERE caa.operating_unit_id = p_ou_id

Line 2874: xla_ae_lines xal,

2870: l_program_update_date,
2871: xal.ae_header_id,
2872: xal.ae_line_num
2873: FROM xla_ae_headers xah,
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

Line 3010: xla_ae_lines xal,

3006: l_program_update_date,
3007: xal.ae_header_id,
3008: xal.ae_line_num
3009: FROM xla_ae_headers xah,
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,

Line 3092: xla_ae_lines xal,

3088: l_program_update_date,
3089: xal.ae_header_id,
3090: xal.ae_line_num
3091: FROM xla_ae_headers xah,
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,

Line 3660: xla_ae_lines xal,

3656: FROM rcv_transactions rct,
3657: rcv_accounting_events rae,
3658: rcv_receiving_sub_ledger rrs,
3659: xla_ae_headers xah,
3660: xla_ae_lines xal,
3661: xla_transaction_entities_upg xte,
3662: xla_distribution_links xdl,
3663: po_headers_all poh,
3664: po_lines_all pol,

Line 3781: xla_ae_lines xal,

3777: gmf_rcv_accounting_txns grat,
3778: gmf_xla_extract_headers geh,
3779: gmf_xla_extract_lines gel,
3780: xla_ae_headers xah,
3781: xla_ae_lines xal,
3782: xla_transaction_entities_upg xte,
3783: xla_distribution_links xdl,
3784: po_headers_all poh,
3785: po_lines_all pol,

Line 3947: xla_ae_lines xal,

3943: WHERE po_distribution_id = po_dists_tab(indx)) aida,
3944: -- ap_invoice_distributions_all aida,
3945: --}
3946: xla_ae_headers xah,
3947: xla_ae_lines xal,
3948: xla_distribution_links xdl,
3949: po_lines_all pol,
3950: po_distributions_all pod,
3951: cst_accrual_accounts caa,