DBA Data[Home] [Help]

APPS.ZX_JG_EXTRACT_PKG dependencies on XLA_ASSIGNMENT_DEFNS_B

Line 747: xla_assignment_defns_b asd

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

Line 780: xla_assignment_defns_b asd

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

Line 1089: xla_assignment_defns_b asd

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

Line 1138: xla_assignment_defns_b asd

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

Line 1183: xla_assignment_defns_b asd

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
1185: cr.cash_receipt_id = :c_trx_id AND
1186: cr.cash_receipt_id = mcd.cash_receipt_id AND
1187: d.source_table = ''MCD'' AND

Line 1225: xla_assignment_defns_b asd

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
1227: cr.cash_receipt_id = :c_trx_id AND
1228: cr.cash_receipt_id = mcd.cash_receipt_id AND
1229: d.source_table = ''MCD'' AND

Line 1292: xla_assignment_defns_b asd

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

Line 1908: xla_assignment_defns_b asd

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'
1911: AND trl_tmp.entity_code = 'AP_INVOICES'
1912: AND trl_tmp.detail_tax_line_id = act.detail_tax_line_id

Line 1970: xla_assignment_defns_b asd

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'
1973: AND trl_tmp.entity_code = 'AP_INVOICES'
1974: AND trl_tmp.event_class_code = 'STANDARD INVOICES'