[Home] [Help]
109: ,FND_NUMBER.CANONICAL_TO_NUMBER(RACTL.GLOBAL_ATTRIBUTE11)
110: ,0))
111: INTO X_ICMS_TAX_AMOUNT,X_ICMS_TAX_RATE,X_ICMS_TAX_BASE_AMOUNT
112: FROM
113: RA_CUSTOMER_TRX_LINES RACTL,
114: AR_VAT_TAX ARVT
115: WHERE RACTL.LINE_TYPE = 'TAX'
116: AND RACTL.LINK_TO_CUST_TRX_LINE_ID = C_DTL_TRX_LINE_ID
117: AND ARVT.VAT_TAX_ID = RACTL.VAT_TAX_ID
136: ,RACTL.EXTENDED_AMOUNT
137: ,0))
138: INTO X_ISS_TAX_AMOUNT
139: FROM
140: RA_CUSTOMER_TRX_LINES RACTL,
141: AR_VAT_TAX ARVT
142: WHERE RACTL.LINE_TYPE = 'TAX'
143: AND RACTL.LINK_TO_CUST_TRX_LINE_ID = C_DTL_TRX_LINE_ID
144: AND ARVT.VAT_TAX_ID = RACTL.VAT_TAX_ID
161: ,RACTL.EXTENDED_AMOUNT
162: ,0))
163: INTO X_IRJ_TAX_AMOUNT
164: FROM
165: RA_CUSTOMER_TRX_LINES RACTL,
166: AR_VAT_TAX ARVT
167: WHERE RACTL.LINE_TYPE = 'TAX'
168: AND RACTL.LINK_TO_CUST_TRX_LINE_ID = C_DTL_TRX_LINE_ID
169: AND ARVT.VAT_TAX_ID = RACTL.VAT_TAX_ID
191: ,FND_NUMBER.CANONICAL_TO_NUMBER(RACTL.GLOBAL_ATTRIBUTE11)
192: ,0))
193: INTO X_ICMSST_TAX_AMOUNT,X_ICMSST_TAX_BASE_AMOUNT
194: FROM
195: RA_CUSTOMER_TRX_LINES RACTL,
196: AR_VAT_TAX ARVT
197: WHERE RACTL.LINE_TYPE = 'TAX'
198: AND RACTL.LINK_TO_CUST_TRX_LINE_ID = C_DTL_TRX_LINE_ID
199: AND ARVT.VAT_TAX_ID = RACTL.VAT_TAX_ID
421: ,NULL
422: ,PRODUCT_FISC_CLASSIFICATION
423: ,PRODUCT_CATEGORY) FISCAL_CLASS_CODE
424: FROM
425: RA_CUSTOMER_TRX_LINES RACTL,
426: ZX_LINES_DET_FACTORS ZLD
427: WHERE RACTL.CUSTOMER_TRX_ID = C_CUSTOMER_TRX_ID
428: AND ZLD.APPLICATION_ID = 222
429: AND ZLD.ENTITY_CODE = 'TRANSACTIONS'
515: ,0)
516: ,0))
517: INTO X_IPI_TAX_AMOUNT,X_IPI_TAX_RATE
518: FROM
519: RA_CUSTOMER_TRX_LINES RACTL,
520: AR_VAT_TAX ARVT
521: WHERE RACTL.LINE_TYPE = 'TAX'
522: AND RACTL.LINK_TO_CUST_TRX_LINE_ID = C_DTL_TRX_LINE_ID
523: AND ARVT.VAT_TAX_ID = RACTL.VAT_TAX_ID