DBA Data[Home] [Help]

APPS.ZX_TRD_SERVICES_PUB_PKG dependencies on ZX_REVERSE_DIST_GT

Line 1990: FROM zx_reverse_dist_gt);

1986: trx_id) IN (SELECT DISTINCT reversing_appln_id,
1987: reversing_entity_code,
1988: reversing_evnt_cls_code,
1989: reversing_trx_id
1990: FROM zx_reverse_dist_gt);
1991: -- Bug 9088833
1992:
1993: -- Bug 9883546
1994: IF l_dist_count = 0 THEN --quick credit memo creation. Query in ELSE part is in the original/previous version.

Line 2025: FROM zx_rec_nrec_dist zd, zx_reverse_dist_gt gt,

2021: l_summary_tax_line_id_tbl,
2022: l_rvrsng_trx_number_tbl,
2023: l_org_id_tbl,
2024: l_gl_date_tbl
2025: FROM zx_rec_nrec_dist zd, zx_reverse_dist_gt gt,
2026: --Bug 9883546
2027: zx_reverse_trx_lines_gt lines_gt, zx_lines zl
2028: WHERE zd.application_id = gt.reversed_appln_id
2029: AND zd.entity_code = gt.reversed_entity_code

Line 2107: FROM zx_rec_nrec_dist zd, zx_reverse_dist_gt gt, zx_lines zl

2103: l_summary_tax_line_id_tbl,
2104: l_rvrsng_trx_number_tbl,
2105: l_org_id_tbl,
2106: l_gl_date_tbl
2107: FROM zx_rec_nrec_dist zd, zx_reverse_dist_gt gt, zx_lines zl
2108: WHERE zd.application_id = gt.reversed_appln_id
2109: AND zd.entity_code = gt.reversed_entity_code
2110: AND zd.event_class_code = gt.reversed_evnt_cls_code
2111: AND zd.trx_id = gt.reversed_trx_id