DBA Data[Home] [Help]

APPS.ZX_JG_EXTRACT_PKG dependencies on XLA_AE_HEADERS

Line 801: xla_ae_headers aeh,

797: zx_dist.prd_tax_amt,
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

Line 834: xla_ae_headers aeh,

830: zx_dist.rec_nrec_tax_amt,
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

Line 1024: xla_ae_headers aeh,

1020: 0 tax_amt, -- -1*zx_dist.prd_tax_amt tax_amt,
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

Line 1053: xla_ae_headers aeh,

1049: -1*zx_dist.prd_tax_amt tax_amt,
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

Line 1179: xla_ae_headers aeh,

1175: '|| l_ar_adjustments ||' adj,
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

Line 1224: xla_ae_headers aeh,

1220: '|| l_ar_adjustments ||' adj,
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

Line 1268: xla_ae_headers aeh,

1264: '|| l_ar_cash_receipts ||' cr,
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

Line 1306: xla_ae_headers aeh,

1302: '|| l_ar_cash_receipts ||' cr,
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

Line 1348: xla_ae_headers aeh,

1344: '|| l_ar_receivable_applications ||' ra,
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