DBA Data[Home] [Help]

APPS.JAI_RCV_RCV_RTV_PKG dependencies on JAI_RCV_LINE_TAXES

Line 1209: from JAI_RCV_LINE_TAXES jrtl,

1205: nvl(jtc.mod_cr_percentage, 0) recoverable, /* Service */
1206: nvl(jrtl.modvat_flag, 'N') modvatable /* Service */
1207: , nvl(tax_types.regime_code, 'XXXX') regime_code /* Vijay Shankar for Bug#4250236(4245089). VAT Impl. */
1208:
1209: from JAI_RCV_LINE_TAXES jrtl,
1210: JAI_CMN_TAXES_ALL jtc
1211: , jai_regime_tax_types_v tax_types /*Vijay Shankar for Bug#4250236(4245089). VAT Impl. */
1212: where jrtl.shipment_line_id = cp_shipment_line_id
1213: AND jrtl.tax_id = jtc.tax_id

Line 2943: from JAI_RCV_LINE_TAXES jrtl,

2939: )
2940: , NVL(jtc.rounding_factor, 0)
2941: )--rchandan for bug#6971526 end
2942: ) tax_amount_by_account
2943: from JAI_RCV_LINE_TAXES jrtl,
2944: JAI_CMN_TAXES_ALL jtc
2945: where jrtl.shipment_line_id = cp_shipment_line_id
2946: and jrtl.tax_id = jtc.tax_id
2947: and ( nvl(jtc.mod_cr_percentage,0) between 0 and 100 ) --rchandan for bug#6971526