[Home] [Help]
872: of the invoice lines and tax lines in -- and they pass them back
873: out. This should be enough to let me get what I need from
874: ra_interface_lines
875:
876: 4) changed zx_detail_tax_lines_gt to zx_lines at request of santosh
877: during IM conv on 25-MAY. Apparently, zx_detail_tax_lines_gt
878: is only for quotes.
879:
880: 5) Identified a loose end where we were not populating prev_cust_trx_line_id
947: p_request_id,
948: zxt.tax_amt,
949: zxt.tax_rate,
950: DECODE(NVL(zxt.manually_entered_flag, 'N'), 'Y', NULL, 'Y'),
951: zxt.tax_amt_included_flag, -- either Y or N from zx_lines
952: zxt.taxable_amt,
953: zxt.tax_rate_id,
954: zxt.tax_line_id,
955: inv_lin.customer_trx_line_id,
969: mtax.interface_line_attribute13,
970: mtax.interface_line_attribute14,
971: mtax.interface_line_attribute15,
972: plin.org_id
973: FROM ZX_LINES zxt,
974: RA_CUSTOMER_TRX_LINES plin,
975: RA_INTERFACE_LINES mtax,
976: ZX_LINES inv_zxt,
977: RA_CUSTOMER_TRX_LINES inv_lin
972: plin.org_id
973: FROM ZX_LINES zxt,
974: RA_CUSTOMER_TRX_LINES plin,
975: RA_INTERFACE_LINES mtax,
976: ZX_LINES inv_zxt,
977: RA_CUSTOMER_TRX_LINES inv_lin
978: WHERE plin.request_id = p_request_id
979: AND zxt.application_id = 222
980: AND zxt.entity_code = 'TRANSACTIONS'
993:
994: IF l_rows > 0
995: THEN
996: /* Stamp transaction lines with tax_classification
997: from ZX_LINES_DET_FACTORS */
998: arp_etax_util.set_default_tax_classification(p_request_id, p_phase);
999:
1000: /* adjust for inclusive tax */
1001: arp_etax_util.adjust_for_inclusive_tax(null, p_request_id, p_phase);