DBA Data[Home] [Help]

APPS.ZX_JG_EXTRACT_PKG dependencies on XLA_AE_LINES

Line 802: xla_ae_lines ael,

798: zx_dist.prd_tax_amt_funcl_curr
799: FROM zx_rec_nrec_dist zx_dist,
800: xla_distribution_links lnk,
801: xla_ae_headers aeh,
802: xla_ae_lines ael,
803: xla_acct_class_assgns acs,
804: xla_assignment_defns_b asd
805: WHERE zx_dist.trx_id = c_trx_id
806: AND zx_dist.tax_line_id = c_tax_line_id

Line 835: xla_ae_lines ael,

831: zx_dist.rec_nrec_tax_amt_funcl_curr
832: FROM zx_rec_nrec_dist zx_dist,
833: xla_distribution_links lnk,
834: xla_ae_headers aeh,
835: xla_ae_lines ael,
836: xla_acct_class_assgns acs,
837: xla_assignment_defns_b asd
838: WHERE zx_dist.trx_id = c_trx_id
839: AND zx_dist.tax_line_id = c_tax_line_id

Line 1025: xla_ae_lines ael,

1021: 0 tax_amt_funcl_curr -- -1*zx_dist.prd_tax_amt_funcl_curr tax_amt_funcl_curr
1022: FROM ra_cust_trx_line_gl_dist_all gl_dist,
1023: xla_distribution_links lnk,
1024: xla_ae_headers aeh,
1025: xla_ae_lines ael,
1026: xla_acct_class_assgns acs,
1027: xla_assignment_defns_b asd
1028: WHERE gl_dist.customer_trx_id = c_trx_id
1029: AND gl_dist.customer_trx_line_id = c_trx_line_id

Line 1054: xla_ae_lines ael,

1050: -1*zx_dist.prd_tax_amt_funcl_curr tax_amt_funcl_curr
1051: FROM zx_rec_nrec_dist zx_dist,
1052: xla_distribution_links lnk,
1053: xla_ae_headers aeh,
1054: xla_ae_lines ael,
1055: xla_acct_class_assgns acs,
1056: xla_assignment_defns_b asd
1057: WHERE zx_dist.trx_id = c_trx_id
1058: AND zx_dist.tax_line_id = c_tax_line_id

Line 1180: xla_ae_lines ael,

1176: '|| l_ra_customer_trx ||' trx,
1177: fnd_currencies curr,
1178: xla_distribution_links lnk,
1179: xla_ae_headers aeh,
1180: xla_ae_lines ael,
1181: xla_acct_class_assgns acs,
1182: xla_assignment_defns_b asd
1183: WHERE
1184: adj.adjustment_id = :c_trx_id AND

Line 1225: xla_ae_lines ael,

1221: '|| l_ra_customer_trx ||' trx,
1222: fnd_currencies curr,
1223: xla_distribution_links lnk,
1224: xla_ae_headers aeh,
1225: xla_ae_lines ael,
1226: xla_acct_class_assgns acs,
1227: xla_assignment_defns_b asd
1228: WHERE
1229: adj.adjustment_id = :c_trx_id AND

Line 1269: xla_ae_lines ael,

1265: '|| l_ar_misc_cash_distributions ||' mcd,
1266: '|| l_ar_distributions ||' d,
1267: xla_distribution_links lnk,
1268: xla_ae_headers aeh,
1269: xla_ae_lines ael,
1270: fnd_currencies curr,
1271: xla_acct_class_assgns acs,
1272: xla_assignment_defns_b asd
1273: WHERE

Line 1307: xla_ae_lines ael,

1303: '|| l_ar_misc_cash_distributions ||' mcd,
1304: '|| l_ar_distributions ||' d,
1305: xla_distribution_links lnk,
1306: xla_ae_headers aeh,
1307: xla_ae_lines ael,
1308: fnd_currencies curr,
1309: xla_acct_class_assgns acs,
1310: xla_assignment_defns_b asd
1311: WHERE

Line 1349: xla_ae_lines ael,

1345: '|| l_ar_cash_receipts ||' cr,
1346: fnd_currencies curr,
1347: xla_distribution_links lnk,
1348: xla_ae_headers aeh,
1349: xla_ae_lines ael,
1350: xla_acct_class_assgns acs,
1351: xla_assignment_defns_b asd
1352: WHERE
1353: -- dtax.line_id = :c_acctg_dist_id AND