APPS.ZX_TRD_SERVICES_PUB_PKG dependencies on ZX_ITM_DISTRIBUTIONS_GT

Line 127: SELECT /*+ INDEX(ZX_ITM_DISTRIBUTIONS_GT ZX_ITM_DISTRIBUTIONS_GT_U1 ZX_ITM_DISTRIBUTIONS_GT_U1) */

123:
124: CURSOR get_item_dist_csr(
125: c_trx_line_id zx_lines.trx_line_id%TYPE,
126: c_trx_level_type zx_lines.trx_level_type%TYPE) IS
127: SELECT /*+ INDEX(ZX_ITM_DISTRIBUTIONS_GT ZX_ITM_DISTRIBUTIONS_GT_U1 ZX_ITM_DISTRIBUTIONS_GT_U1) */
128: trx_line_dist_id,
129: trx_line_id,
130: trx_level_type,
131: dist_level_action,

Line 175: FROM zx_itm_distributions_gt

171: -- adjusted_doc_trx_level_type,
172: trx_line_dist_date, -- AP passes account_date
173: char4, --Bug 11675911 / Bug 10621602
174: char5
175: FROM zx_itm_distributions_gt
176: WHERE trx_id = p_event_class_rec.trx_id
177: AND application_id = p_event_class_rec.application_id
178: AND entity_code = p_event_class_rec.entity_code
179: AND event_class_code = p_event_class_rec.event_class_code

Line 523: -- zx_itm_distributions_gt into pl/sql tables

519: END IF;
520: ELSE
521:
522: -- Fetch item distributions of this transaction line from
523: -- zx_itm_distributions_gt into pl/sql tables
524: --
525: OPEN get_item_dist_csr(l_trx_line_id, l_trx_level_type);
526: FETCH get_item_dist_csr BULK COLLECT INTO
527: trx_line_dist_id_tbl,

Line 3755: INSERT INTO zx_itm_distributions_gt(

3751: 'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.INSERT_ITEM_DIST.BEGIN',
3752: 'ZX_TRD_SERVICES_PUB_PKG.INSERT_ITEM_DIST(+)');
3753: END IF;
3754:
3755: INSERT INTO zx_itm_distributions_gt(
3756: --internal_organization_id,
3757: application_id,
3758: entity_code,
3759: event_class_code,