APPS.FV_GTAS_GL_PKG dependencies on XLA_AE_LINES

Line 1079: xla_ae_lines xl ,

1075: SELECT xd.source_distribution_id_num_1 transaction_id,
1076: xte.transaction_number
1077: --, (NVL(xd.unrounded_accounted_dr,0) - NVL(xd.unrounded_accounted_cr,0)) amount
1078: FROM gl_import_references gli,
1079: xla_ae_lines xl ,
1080: xla_ae_headers xh ,
1081: xla_distribution_links xd,
1082: xla_transaction_entities xte
1083: WHERE gli.je_batch_id = p_je_batch_id

Line 1577: xla_ae_lines ael,

1573: SELECT ael.party_id,
1574: NVL(ael.accounted_dr,0) - NVL(ael.accounted_cr,0) amount,
1575: xte.transaction_number
1576: FROM gl_import_references i,
1577: xla_ae_lines ael,
1578: xla_ae_headers aeh,
1579: xla_transaction_entities xte
1580: WHERE i.je_batch_id = p_je_batch_id
1581: AND i.je_header_id = p_je_header_id

Line 1597: xla_ae_lines ael ,

1593: NVL(ael.accounted_dr,0) - NVL(ael.accounted_cr,0) amount,
1594: xte.transaction_number
1595: FROM gl_je_lines je ,
1596: gl_import_references gir ,
1597: xla_ae_lines ael ,
1598: xla_ae_headers aeh ,
1599: pa_draft_revenues_all pdr,
1600: pa_agreements_all agr ,
1601: pa_project_customers pc,

Line 1624: xla_ae_lines xl ,

1620: bd.transaction_id,
1621: bd.dept_id, bd.main_account,
1622: bh.doc_number
1623: FROM gl_import_references gli,
1624: xla_ae_lines xl ,
1625: xla_ae_headers xh ,
1626: xla_distribution_links xd,
1627: xla_transaction_entities xte,
1628: fv_be_trx_dtls bd,

Line 1649: xla_ae_lines xl ,

1645: SELECT
1646: (NVL(xd.unrounded_accounted_dr,0)-NVL(xd.unrounded_accounted_cr,0)) amount,
1647: reference4 doc_num, poh.vendor_id, rc.rcv_transaction_id
1648: FROM gl_import_references gli,
1649: xla_ae_lines xl ,
1650: xla_ae_headers xh ,
1651: xla_distribution_links xd,
1652: rcv_receiving_sub_ledger rc,
1653: po_headers_all poh

Line 1672: xla_ae_lines xl ,

1668: SELECT
1669: (NVL(xd.unrounded_accounted_dr,0)-NVL(xd.unrounded_accounted_cr,0)) amount,
1670: aip.check_id
1671: FROM gl_import_references gli,
1672: xla_ae_lines xl ,
1673: xla_ae_headers xh ,
1674: xla_distribution_links xd,
1675: ap_invoice_payments_all aip,
1676: ap_payment_hist_dists aphd

Line 2281: xla_ae_lines l,

2277: CURSOR event_lines_cur IS
2278: SELECT event_id
2279: INTO l_sla_event_id
2280: FROM gl_import_references gli,
2281: xla_ae_lines l,
2282: xla_ae_headers h
2283: WHERE gli.je_batch_id = p_je_batch_id
2284: AND gli.je_header_id = p_je_header_id
2285: AND gli.je_line_num = p_je_line_num

Line 2308: xla_ae_lines l,

2304: /*
2305: SELECT event_id
2306: INTO l_sla_event_id
2307: FROM gl_import_references gli,
2308: xla_ae_lines l,
2309: xla_ae_headers h
2310: WHERE gli.je_batch_id = p_je_batch_id
2311: AND gli.je_header_id = p_je_header_id
2312: AND gli.je_line_num = p_je_line_num;

Line 2320: xla_ae_lines xl,

2316: FOR sla_event in event_lines_cur LOOP
2317:
2318: l_acct_select := 'SELECT SUBSTR(ffv.compiled_value_attributes,5,1)
2319: FROM xla_ae_headers xh,
2320: xla_ae_lines xl,
2321: gl_code_combinations gcc,
2322: fnd_flex_values ffv
2323: WHERE xh.event_id = '||sla_event.event_id||
2324: ' AND xh.ae_header_id = xl.ae_header_id