DBA Data[Home] [Help]

APPS.CST_ACCRUAL_LOAD dependencies on XLA_DISTRIBUTION_LINKS

Line 1157: xla_distribution_links xld, --BUG#7275286

1153: pawo.program_update_date
1154: FROM
1155: po_accrual_write_offs_all pawo,
1156: rcv_receiving_sub_ledger rrs,
1157: xla_distribution_links xld, --BUG#7275286
1158: rcv_transactions rt,
1159: po_headers_all poh
1160: ,cst_accrual_accounts ca --BUG#7528609
1161: WHERE pawo.org_id = p_operating_unit

Line 1281: xla_distribution_links xld

1277: financials_system_params_all fsp,
1278: gl_sets_of_books gsob,
1279: fnd_currencies fc,
1280: ap_ae_lines_all aal,
1281: xla_distribution_links xld
1282: ,cst_accrual_accounts ca
1283: WHERE pawo.org_id = p_operating_unit
1284: AND pawo.po_distribution_id IS NULL -- Misc Invoices
1285: AND pawo.transaction_source_code = 'AP'

Line 1416: xla_distribution_links xld

1412: gl_sets_of_books gsob,
1413: fnd_currencies fc,
1414: ap_ae_lines_all aal,
1415: cst_accrual_accounts caa,
1416: xla_distribution_links xld
1417: WHERE pawo.org_id = p_operating_unit
1418: AND pawo.po_distribution_id IS NULL -- Misc Invoices
1419: AND pawo.transaction_source_code = 'AP'
1420: AND pawo.invoice_id IS NOT NULL

Line 1562: xla_distribution_links xld,

1558: gl_sets_of_books gsob,
1559: fnd_currencies fc,
1560: ap_ae_lines aal,
1561: cst_accrual_accounts caa,
1562: xla_distribution_links xld,
1563: xla_ae_lines xal
1564: WHERE pawo.org_id = p_operating_unit
1565: AND pawo.po_distribution_id IS NOT NULL -- Reg Invoices and consigned
1566: AND pod.po_distribution_id = pawo.po_distribution_id

Line 1729: xla_distribution_links xld

1725: gl_sets_of_books gsob,
1726: fnd_currencies fc,
1727: ap_ae_lines aal,
1728: cst_accrual_accounts caa,
1729: xla_distribution_links xld
1730: WHERE pawo.org_id = p_operating_unit
1731: AND pawo.po_distribution_id IS NOT NULL -- Reg Invoices and consigned
1732: AND pod.po_distribution_id = pawo.po_distribution_id
1733: AND pra.po_release_id(+) = pod.po_release_id

Line 1870: xla_distribution_links xld

1866: pawo.program_id,
1867: pawo.program_update_date
1868: FROM po_accrual_write_offs_all pawo,
1869: mtl_transaction_accounts mta,
1870: xla_distribution_links xld
1871: ,cst_accrual_accounts ca --BUG#7528609
1872: WHERE pawo.transaction_source_code = 'INV'
1873: AND pawo.org_id = p_operating_unit
1874: AND pawo.inv_transaction_id = mta.transaction_id

Line 1974: xla_distribution_links xld,

1970: cwo.program_update_date
1971: FROM cst_write_offs cwo,
1972: po_accrual_write_offs_all pawo,
1973: mtl_transaction_accounts mta,
1974: xla_distribution_links xld,
1975: cst_accrual_accounts ca --BUG7528609
1976: WHERE pawo.org_id = p_operating_unit
1977: AND pawo.transaction_source_code ='INV'
1978: AND cwo.write_off_id = pawo.write_off_id

Line 2053: xla_distribution_links xld,

2049: po_accrual_write_offs_all pawo,
2050: po_lookup_codes plc,
2051: rcv_receiving_sub_ledger rrs,
2052: rcv_transactions rt,
2053: xla_distribution_links xld,
2054: cst_accrual_accounts ca --BUG#7528609
2055: WHERE pawo.org_id = p_operating_unit
2056: AND pawo.transaction_source_code = 'PO'
2057: AND cwo.write_off_id = pawo.write_off_id

Line 2136: xla_distribution_links xld

2132: po_lookup_codes plc,
2133: ap_invoice_distributions_all aida,
2134: ap_ae_lines_all aal,
2135: cst_accrual_accounts ca, --BUG#7528609
2136: xla_distribution_links xld
2137: WHERE pawo.org_id = p_operating_unit
2138: AND pawo.transaction_source_code = 'AP'
2139: AND cwo.write_off_id = pawo.write_off_id
2140: AND plc.lookup_type = 'ACCRUAL TYPE'

Line 2393: xla_distribution_links xdl,

2389: FROM ap_invoices_all apia,
2390: ap_invoice_distributions_all aida,
2391: xla_ae_headers xah,
2392: xla_ae_lines xal,
2393: xla_distribution_links xdl,
2394: cst_accrual_accounts caa,
2395: financials_system_params_all fsp,
2396: po_distributions_all pod,
2397: po_lines_all pol,

Line 3331: xla_distribution_links xdl,

3327: rcv_receiving_sub_ledger rrs,
3328: xla_ae_headers xah,
3329: xla_ae_lines xal,
3330: xla_transaction_entities_upg xte,
3331: xla_distribution_links xdl,
3332: po_headers_all poh,
3333: po_lines_all pol,
3334: po_distributions_all pod,
3335: cst_accrual_accounts caa,

Line 3450: xla_distribution_links xdl,

3446: gmf_xla_extract_lines gel,
3447: xla_ae_headers xah,
3448: xla_ae_lines xal,
3449: xla_transaction_entities_upg xte,
3450: xla_distribution_links xdl,
3451: po_headers_all poh,
3452: po_lines_all pol,
3453: po_distributions_all pod,
3454: cst_accrual_accounts caa,

Line 3585: xla_distribution_links xdl,

3581: FROM
3582: ap_invoice_distributions_all aida,
3583: xla_ae_headers xah,
3584: xla_ae_lines xal,
3585: xla_distribution_links xdl,
3586: po_lines_all pol,
3587: po_distributions_all pod,
3588: cst_accrual_accounts caa,
3589: financials_system_params_all fsp,