[Home] [Help]
603: FROM xla_ae_lines l
604: ,xla_ae_headers h
605: ,xla_event_types_b xet
606: ,financials_system_params_all fsp
607: ,cst_accrual_accounts caa
608: WHERE caa.operating_unit_id = p_ou_id
609: AND fsp.org_id = p_ou_id
610: AND xet.application_id = 707
611: AND xet.entity_code = 'MTL_ACCOUNTING_EVENTS'
678:
679: l_stmt_num := 10;
680: debug(' l_stmt_num:'||l_stmt_num);
681:
682: /* check if there are accounts selected in CST_ACCRUAL_ACCOUNTS table. If not then error out */
683:
684: SELECT count(*)
685: INTO l_acc_accounts
686: FROM cst_accrual_accounts
682: /* check if there are accounts selected in CST_ACCRUAL_ACCOUNTS table. If not then error out */
683:
684: SELECT count(*)
685: INTO l_acc_accounts
686: FROM cst_accrual_accounts
687: WHERE operating_unit_id = p_operating_unit
688: AND ROWNUM = 1;
689:
690: debug(' l_acc_accounts:'||l_acc_accounts);
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
1162: AND pawo.transaction_source_code = 'PO'
1163: AND pawo.po_transaction_id IS NOT NULL
1164: AND rrs.rcv_transaction_id = pawo.po_transaction_id
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'
1286: AND pawo.invoice_id IS NOT NULL
1411: financials_system_params_all fsp,
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'
1557: financials_system_params_all fsp,
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
1724: financials_system_params_all fsp,
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
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
1875: --{BUG#7528609
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
1979: AND pawo.inv_transaction_id = mta.transaction_id
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
2058: AND plc.displayed_field = pawo.accrual_code
2131: po_accrual_write_offs_all pawo,
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
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,
2398: --{BUG#7554120
2666: FROM xla_ae_headers xah,
2667: xla_ae_lines xal,
2668: xla_transaction_entities_upg xte,
2669: mtl_material_transactions mmt,
2670: cst_accrual_accounts caa,
2671: financials_system_params_all fsp
2672: WHERE xal.code_combination_id = caa.accrual_account_id
2673: AND caa.operating_unit_id = p_operating_unit
2674: AND fsp.org_id = p_operating_unit
2796: FROM xla_ae_headers xah,
2797: xla_ae_lines xal,
2798: xla_transaction_entities_upg xte,
2799: mtl_material_transactions mmt,
2800: cst_accrual_accounts caa,
2801: financials_system_params_all fsp
2802: WHERE xal.code_combination_id = caa.accrual_account_id
2803: AND caa.operating_unit_id = p_operating_unit
2804: AND fsp.org_id = p_operating_unit
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,
3336: financials_system_params_all fsp
3337: WHERE fsp.org_id = p_operating_unit
3338: AND xah.ledger_id = fsp.set_of_books_id
3339: AND xah.application_id = 707
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,
3455: financials_system_params_all fsp
3456: WHERE fsp.org_id = p_operating_unit
3457: AND xah.ledger_id = fsp.set_of_books_id
3458: AND xah.application_id = 555
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,
3590: xla_transaction_entities_upg xte,
3591: po_headers_all poh /* -- Changes to pick Vendor from PO instead of APIA. Bug 7312170 */
3592: WHERE xal.code_combination_id = caa.accrual_account_id