DBA Data[Home] [Help]

APPS.JAI_TRX_REPO_EXTRACT_PKG dependencies on JAI_OM_OE_RMA_TAXES

Line 988: , JAI_OM_OE_RMA_TAXES jrtl

984: cursor c_get_rma_line_srvtyp (cp_line_id jai_om_oe_so_lines.line_id%type )
985: is
986: select service_type_code, sum(jrtl.tax_amount) service_tax_amount
987: from JAI_OM_OE_RMA_LINES jrl
988: , JAI_OM_OE_RMA_TAXES jrtl
989: , JAI_CMN_TAXES_ALL jtc
990: where jrl.rma_line_id = cp_line_id
991: and jrl.rma_line_id = jrtl.rma_line_id
992: and jrtl.tax_id = jtc.tax_id