[Home] [Help]
600: p_to_date IN DATE)
601: IS
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
2387: xal.ae_header_id,
2388: xal.ae_line_num
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,
2662: l_program_id,
2663: l_program_update_date,
2664: xal.ae_header_id,
2665: xal.ae_line_num
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,
2792: l_program_id,
2793: l_program_update_date,
2794: xal.ae_header_id,
2795: xal.ae_line_num
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,
3324: xal.ae_line_num
3325: FROM rcv_transactions rct,
3326: rcv_accounting_events rae,
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,
3443: FROM rcv_transactions rct,
3444: gmf_rcv_accounting_txns grat,
3445: gmf_xla_extract_headers geh,
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,
3579: xal.ae_header_id,
3580: xal.ae_line_num
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,