DBA Data[Home] [Help]

APPS.ZX_JG_EXTRACT_PKG dependencies on XLA_ASSIGNMENT_DEFNS_B

Line 804: xla_assignment_defns_b asd

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
807: AND zx_dist.trx_line_id = c_trx_line_id
808: AND lnk.application_id = 200

Line 837: xla_assignment_defns_b asd

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
840: AND zx_dist.trx_line_id = c_trx_line_id
841: AND lnk.application_id = 200

Line 1027: xla_assignment_defns_b asd

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
1030: AND gl_dist.account_class = 'REV'
1031: AND lnk.application_id = 222

Line 1056: xla_assignment_defns_b asd

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
1059: AND zx_dist.trx_line_id = c_trx_line_id
1060: AND lnk.application_id = 222

Line 1182: xla_assignment_defns_b asd

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
1185: trx.customer_trx_id = adj.customer_trx_id AND
1186: adjlndist.source_id = adj.adjustment_id AND

Line 1227: xla_assignment_defns_b asd

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
1230: trx.customer_trx_id = adj.customer_trx_id AND
1231: adjlndist.source_id = adj.adjustment_id AND

Line 1272: xla_assignment_defns_b asd

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
1274: cr.cash_receipt_id = :c_trx_id AND
1275: cr.cash_receipt_id = mcd.cash_receipt_id AND
1276: d.source_table = ''MCD'' AND

Line 1310: xla_assignment_defns_b asd

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
1312: cr.cash_receipt_id = :c_trx_id AND
1313: cr.cash_receipt_id = mcd.cash_receipt_id AND
1314: d.source_table = ''MCD'' AND

Line 1351: xla_assignment_defns_b asd

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
1354: cr.cash_receipt_id = :c_trx_id AND
1355: dtax.source_table = ''RA'' AND