DBA Data[Home] [Help]

APPS.ZX_JG_EXTRACT_PKG dependencies on XLA_ACCT_CLASS_ASSGNS

Line 746: xla_acct_class_assgns acs,

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

Line 779: xla_acct_class_assgns acs,

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

Line 1088: xla_acct_class_assgns acs,

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

Line 1137: xla_acct_class_assgns acs,

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

Line 1182: xla_acct_class_assgns acs,

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
1185: cr.cash_receipt_id = :c_trx_id AND
1186: cr.cash_receipt_id = mcd.cash_receipt_id AND

Line 1224: xla_acct_class_assgns acs,

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
1227: cr.cash_receipt_id = :c_trx_id AND
1228: cr.cash_receipt_id = mcd.cash_receipt_id AND

Line 1291: xla_acct_class_assgns acs,

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
1295: cr.cash_receipt_id = :c_trx_id AND

Line 1907: xla_acct_class_assgns acs,

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

Line 1969: xla_acct_class_assgns acs,

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