DBA Data[Home] [Help]

APPS.JAI_TRX_REPO_EXTRACT_PKG dependencies on JAI_RCV_LINE_TAXES

Line 1628: ,jai_rcv_line_taxes jrlt

1624: cursor c_get_rcv_line_loc_srvtyp (cp_po_line_id po_lines_all.po_line_id%type )
1625: is
1626: select service_type_code, sum(jrlt.tax_amount) service_tax_amount
1627: from JAI_PO_LINE_LOCATIONS jpoll
1628: ,jai_rcv_line_taxes jrlt
1629: ,rcv_transactions rt
1630: where jpoll.po_line_id = cp_po_line_id
1631: and rt.po_line_id = cp_po_line_id
1632: and rt.transaction_type = 'DELIVER'

Line 2963: jai_rcv_line_taxes jrtxl -- join to ja_in_receipt_tax_lines added by vumaasha for 6856213

2959: ORDER BY jrtxl.shipment_line_id,jrtxl.tax_line_no) rn
2960: FROM jai_rcv_lines jrt,
2961: jai_rcv_transactions jirt,/* modified by vumaasha for bug 8965721 */
2962: jai_rcv_tp_invoices jrti,
2963: jai_rcv_line_taxes jrtxl -- join to ja_in_receipt_tax_lines added by vumaasha for 6856213
2964: WHERE jrt.shipment_header_id = jrti.shipment_header_id
2965: AND jrti.invoice_id = p_invoice_id
2966: AND jrti.shipment_header_id = jirt.shipment_header_id
2967: AND jirt.transaction_type = 'RECEIVE'