[Home] [Help]
602: SELECT 'Y'
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
849: SELECT NVL(fc.minimum_accountable_unit,power(10,NVL(-fc.precision,0)))
850: INTO l_round_unit
851: FROM fnd_currencies fc,
852: gl_sets_of_books gsb,
853: financials_system_params_all fsp
854: WHERE fsp.org_id = p_operating_unit
855: AND fsp.set_of_books_id = gsb.set_of_books_id
856: AND fc.currency_code = gsb.currency_code;
857:
1273: pawo.program_update_date
1274: FROM
1275: po_accrual_write_offs_all pawo,
1276: ap_invoice_distributions_all aida,
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
1407: pawo.program_update_date
1408: FROM
1409: po_accrual_write_offs_all pawo,
1410: ap_invoice_distributions_all aida,
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,
1553: po_distributions_all pod,
1554: po_releases_all pra,
1555: po_headers_all poh,
1556: ap_invoice_distributions_all aida,
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,
1720: po_distributions_all pod,
1721: po_releases_all pra,
1722: po_headers_all poh,
1723: ap_invoice_distributions_all aida,
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,
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
2399: po_headers_all poh
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
2675: AND fsp.set_of_books_id = xah.ledger_id
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
2805: AND fsp.set_of_books_id = xah.ledger_id
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
3340: AND xal.application_id = 707
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
3459: AND xal.application_id = 555
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
3593: AND caa.operating_unit_id = p_operating_unit