APPS.ZX_TRD_SERVICES_PUB_PKG dependencies on ZX_LINES_DET_FACTORS

Line 213: FROM zx_lines_det_factors

209: -- adjusted_doc_line_id,
210: -- applied_from_trx_level_type,
211: -- adjusted_doc_trx_level_type,
212: nvl(trx_line_gl_date, trx_date) -- item dist gl date
213: FROM zx_lines_det_factors
214: WHERE application_id = p_event_class_rec.application_id
215: AND event_class_code = p_event_class_rec.event_class_code
216: AND entity_code = p_event_class_rec.entity_code
217: AND trx_id = p_event_class_rec.trx_id

Line 3855: FROM zx_lines_det_factors

3851: --p_tax_line_rec.doc_event_status,
3852: p_tax_line_rec.tax_amt,
3853: -- 'N', -- Quote_Flag what should it be?
3854: Historical_Flag
3855: FROM zx_lines_det_factors
3856: WHERE application_id = p_tax_line_rec.application_id
3857: AND event_class_code = p_tax_line_rec.event_class_code
3858: AND entity_code = p_tax_line_rec.entity_code
3859: AND trx_id = p_tax_line_rec.trx_id

Line 4236: FROM zx_lines_det_factors

4232: tax_reporting_flag,
4233: input_tax_classification_code,
4234: output_tax_classification_code,
4235: hq_estb_party_tax_prof_id
4236: FROM zx_lines_det_factors
4237: WHERE application_id = p_tax_line_tbl(p_index).application_id
4238: AND entity_code = p_tax_line_tbl(p_index).entity_code
4239: AND event_class_code = p_tax_line_tbl(p_index).event_class_code
4240: AND trx_id = p_tax_line_tbl(p_index).trx_id

Line 4390: 'NO DATA found in zx_lines_det_factors for trx line'||

4386: IF get_trx_info_csr%NOTFOUND THEN
4387: IF (g_level_statement >= g_current_runtime_level ) THEN
4388: FND_LOG.STRING(g_level_statement,
4389: 'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.populate_trx_line_info',
4390: 'NO DATA found in zx_lines_det_factors for trx line'||
4391: p_tax_line_tbl(p_index).trx_line_id);
4392: END IF;
4393: END IF;
4394: CLOSE get_trx_info_csr;

Line 6427: FROM zx_lines_det_factors det, zx_lines

6423: det.rdng_ship_from_pty_tx_prof_id, det.rdng_bill_to_pty_tx_prof_id,
6424: det.rdng_bill_from_pty_tx_prof_id, det.rdng_ship_to_pty_tx_p_st_id,
6425: det.rdng_ship_from_pty_tx_p_st_id, det.rdng_bill_to_pty_tx_p_st_id,
6426: det.rdng_bill_from_pty_tx_p_st_id
6427: FROM zx_lines_det_factors det, zx_lines
6428: WHERE det.trx_id = zx_lines.trx_id
6429: and det.trx_line_id = zx_lines.trx_line_id
6430: and det.application_id = zx_lines.application_id
6431: and det.entity_code = zx_lines.entity_code

Line 6846: SELECT ZX_LINES_DET_FACTORS_S.nextval

6842: 'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.INIT_MAND_COLUMNS.BEGIN',
6843: 'ZX_TRD_SERVICES_PUB_PKG.INIT_MAND_COLUMNS(+)');
6844: END IF;
6845:
6846: SELECT ZX_LINES_DET_FACTORS_S.nextval
6847: INTO p_event_class_rec.event_id
6848: FROM DUAL;
6849:
6850: