[Home] [Help]
340: ,xla_ledger_options xlo
341: ,fnd_currencies fdc
342: ,gl_ledgers gl
343: ,gl_code_combinations gcc
344: ,xla_event_types_b xet
345: ,xla_tb_definitions_b xtd
346: $l_from$
347: WHERE xah.ae_header_id BETWEEN :7 AND :8
348: AND xah.upg_batch_id IS NULL -- added bug 6704677
558: ,SYSDATE program_update_date
559: FROM
560: ap_liability_balance alb
561: ,xla_ae_headers PARTITION (AP) xah
562: ,xla_event_types_b xet
563: ,xla_tb_defn_details xdd
564: ,xla_tb_definitions_b xtd
565: ,xla_tb_defn_je_sources xjs
566: ,xla_subledgers xsu
848: ,SYSDATE program_update_date
849: FROM
850: ap_liability_balance alb
851: ,xla_ae_headers PARTITION (AP) xah
852: ,xla_event_types_b xet
853: ,xla_tb_defn_details xdd
854: ,xla_tb_definitions_b xtd
855: ,xla_tb_defn_je_sources xjs
856: ,xla_subledgers xsu
2634: ,g_prog_appl_id
2635: ,g_program_id
2636: ,SYSDATE
2637: from xla_ae_headers xah,
2638: xla_event_types_b xet,
2639: xla_event_class_attrs xeca,
2640: xla_tb_definitions_b xtd
2641: WHERE xet.event_class_code <> 'MANUAL'
2642: AND xet.event_type_code = xah.event_type_code