[Home] [Help]
741: zx_dist.prd_tax_amt_funcl_curr
742: FROM zx_rec_nrec_dist zx_dist,
743: xla_distribution_links lnk,
744: xla_ae_headers aeh,
745: xla_ae_lines ael,
746: xla_acct_class_assgns acs,
747: xla_assignment_defns_b asd
748: WHERE zx_dist.trx_id = c_trx_id
749: AND zx_dist.tax_line_id = c_tax_line_id
774: zx_dist.rec_nrec_tax_amt_funcl_curr
775: FROM zx_rec_nrec_dist zx_dist,
776: xla_distribution_links lnk,
777: xla_ae_headers aeh,
778: xla_ae_lines ael,
779: xla_acct_class_assgns acs,
780: xla_assignment_defns_b asd
781: WHERE zx_dist.trx_id = c_trx_id
782: AND zx_dist.tax_line_id = c_tax_line_id
1083: '|| l_ra_customer_trx ||' trx,
1084: fnd_currencies curr,
1085: xla_distribution_links lnk,
1086: xla_ae_headers aeh,
1087: xla_ae_lines ael,
1088: xla_acct_class_assgns acs,
1089: xla_assignment_defns_b asd
1090: WHERE
1091: adj.adjustment_id = :c_trx_id AND
1132: '|| l_ra_customer_trx ||' trx,
1133: fnd_currencies curr,
1134: xla_distribution_links lnk,
1135: xla_ae_headers aeh,
1136: xla_ae_lines ael,
1137: xla_acct_class_assgns acs,
1138: xla_assignment_defns_b asd
1139: WHERE
1140: adj.adjustment_id = :c_trx_id AND
1176: '|| l_ar_misc_cash_distributions ||' mcd,
1177: '|| l_ar_distributions ||' d,
1178: xla_distribution_links lnk,
1179: xla_ae_headers aeh,
1180: xla_ae_lines ael,
1181: fnd_currencies curr,
1182: xla_acct_class_assgns acs,
1183: xla_assignment_defns_b asd
1184: WHERE
1218: '|| l_ar_misc_cash_distributions ||' mcd,
1219: '|| l_ar_distributions ||' d,
1220: xla_distribution_links lnk,
1221: xla_ae_headers aeh,
1222: xla_ae_lines ael,
1223: fnd_currencies curr,
1224: xla_acct_class_assgns acs,
1225: xla_assignment_defns_b asd
1226: WHERE
1286: '|| l_ar_cash_receipts ||' cr,
1287: fnd_currencies curr,
1288: xla_distribution_links lnk,
1289: xla_ae_headers aeh,
1290: xla_ae_lines ael,
1291: xla_acct_class_assgns acs,
1292: xla_assignment_defns_b asd
1293: WHERE
1294: -- dtax.line_id = :c_acctg_dist_id AND
1902: zx_rep_actg_ext_t act,
1903: zx_rec_nrec_dist zx_dist,
1904: xla_distribution_links lnk,
1905: xla_ae_headers aeh,
1906: xla_ae_lines ael,
1907: xla_acct_class_assgns acs,
1908: xla_assignment_defns_b asd
1909: WHERE trl_tmp.request_id = g_request_id
1910: AND trl_tmp.extract_source_ledger = 'AP'
1964: ap_invoice_distributions_all ap_dist,
1965: ap_prepay_app_dists pre_dist,
1966: xla_ae_headers aeh,
1967: xla_distribution_links lnk,
1968: xla_ae_lines ael,
1969: xla_acct_class_assgns acs,
1970: xla_assignment_defns_b asd
1971: WHERE trl_tmp.request_id = g_request_id
1972: AND trl_tmp.extract_source_ledger = 'AP'