DBA Data[Home] [Help]

APPS.JL_CO_GL_NIT_MANAGEMENT dependencies on XLA_AE_HEADERS

Line 480: xla_ae_headers aeh,

476: Begin
477: Select distinct ent.entity_code
478: Into l_entity_code
479: From xla_transaction_entities ent,
480: xla_ae_headers aeh,
481: xla_ae_lines ael,
482: gl_import_references imr
483: Where ent.application_id = 200
484: And ent.application_id =aeh.application_id

Line 698: xla_ae_headers AEH,

694: aeh.upg_batch_id UPG_BATCH_ID
695: FROM
696: ap_invoices_all I,
697: xla_transaction_entities ent,
698: xla_ae_headers AEH,
699: xla_ae_lines AEL,
700: ap_invoice_distributions_all D,
701: xla_distribution_links LNK,
702: gl_import_references R

Line 763: xla_ae_headers AEH,

759: aeh.upg_batch_id UPG_BATCH_ID
760: FROM
761: ap_checks_all C,
762: xla_transaction_entities ent,
763: xla_ae_headers AEH,
764: xla_ae_lines AEL,
765: ap_payment_history_all D, -- bug 8673098
766: gl_import_references R
767: WHERE

Line 820: xla_ae_headers AEH,

816: aeh.upg_batch_id UPG_BATCH_ID
817: FROM
818: ap_invoices_all I,
819: xla_transaction_entities ent,
820: xla_ae_headers AEH,
821: xla_ae_lines AEL,
822: ap_prepay_app_dists D,
823: xla_distribution_links LNK,
824: gl_import_references R

Line 887: xla_ae_headers AEH,

883:
884: FROM
885: ap_invoices_all I,
886: xla_transaction_entities ent,
887: xla_ae_headers AEH,
888: xla_ae_lines AEL,
889: gl_import_references R
890: WHERE
891: ent.application_id = 200

Line 1942: xla_ae_headers AEH,

1938: ent.entity_code,
1939: ael.party_id,
1940: et.event_class_code
1941: FROM xla_transaction_entities ent,
1942: xla_ae_headers AEH,
1943: xla_ae_lines AEL,
1944: gl_import_references R,
1945: xla_event_types_b et
1946: WHERE

Line 3166: xla_ae_headers AEH,

3162: Declare
3163: Cursor C_Upg_Batch_ID Is
3164: Select aeh.upg_batch_id upg_batch_id
3165: FROM xla_transaction_entities ent,
3166: xla_ae_headers AEH,
3167: xla_ae_lines AEL,
3168: gl_import_references R
3169: WHERE ent.application_id = 222
3170: AND ent.entity_id = aeh.entity_id

Line 3181: l_upg_batch_id xla_ae_headers.upg_batch_id%Type;

3177: AND ael.application_id = 222
3178: AND R.gl_sl_link_id = AEL.gl_sl_link_id
3179: AND R.je_header_id = j_line.je_header_id
3180: AND R.je_line_num = j_line.je_line_num;
3181: l_upg_batch_id xla_ae_headers.upg_batch_id%Type;
3182: Begin
3183: For Upg_Batch_ID_Rec in C_Upg_Batch_ID Loop
3184: l_upg_batch_id := Upg_Batch_ID_Rec.upg_batch_id;
3185: End Loop;