[Home] [Help]
188: -- adjusted_doc_line_id,
189: -- applied_from_trx_level_type,
190: -- adjusted_doc_trx_level_type,
191: nvl(trx_line_gl_date, trx_date) -- item dist gl date
192: FROM zx_lines_det_factors
193: WHERE application_id = p_event_class_rec.application_id
194: AND event_class_code = p_event_class_rec.event_class_code
195: AND entity_code = p_event_class_rec.entity_code
196: AND trx_id = p_event_class_rec.trx_id
3661: --p_tax_line_rec.doc_event_status,
3662: p_tax_line_rec.tax_amt,
3663: -- 'N', -- Quote_Flag what should it be?
3664: Historical_Flag
3665: FROM zx_lines_det_factors
3666: WHERE application_id = p_tax_line_rec.application_id
3667: AND event_class_code = p_tax_line_rec.event_class_code
3668: AND entity_code = p_tax_line_rec.entity_code
3669: AND trx_id = p_tax_line_rec.trx_id
4001: bill_third_pty_acct_id,
4002: document_sub_type,
4003: -- End : Added columns for Bug#7008557
4004: tax_reporting_flag
4005: FROM zx_lines_det_factors
4006: WHERE application_id = p_tax_line_tbl(p_index).application_id
4007: AND entity_code = p_tax_line_tbl(p_index).entity_code
4008: AND event_class_code = p_tax_line_tbl(p_index).event_class_code
4009: AND trx_id = p_tax_line_tbl(p_index).trx_id
4098: IF get_trx_info_csr%NOTFOUND THEN
4099: IF (g_level_statement >= g_current_runtime_level ) THEN
4100: FND_LOG.STRING(g_level_statement,
4101: 'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.populate_trx_line_info',
4102: 'NO DATA found in zx_lines_det_factors for trx line'||
4103: p_tax_line_tbl(p_index).trx_line_id);
4104: END IF;
4105: END IF;
4106: CLOSE get_trx_info_csr;
6122:
6123: Cursor get_location_id(c_tax_line_id number) is
6124: SELECT det.ship_to_location_id,det.ship_from_location_id,
6125: det.bill_to_location_id,det.bill_from_location_id,det.trx_date
6126: FROM zx_lines_det_factors det, zx_lines
6127: WHERE det.trx_id = zx_lines.trx_id
6128: and det.trx_line_id = zx_lines.trx_line_id
6129: and det.application_id = zx_lines.application_id
6130: and det.entity_code = zx_lines.entity_code