APPS.JAI_TRX_REPO_EXTRACT_PKG dependencies on JAI_RCV_TP_INVOICES

Line 2962: jai_rcv_tp_invoices jrti,

2958: row_number() over(
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

Line 2974: cursor c_get_ra_line_srvtyp(p_vendor_id jai_rcv_tp_invoices.VENDOR_ID%type,p_vendor_site_id jai_rcv_tp_invoices.VENDOR_SITE_ID%type)

2970: AND jrtxl.shipment_header_id = jrti.shipment_header_id
2971: AND jirt.shipment_line_id = jrtxl.shipment_line_id)
2972: WHERE rn =p_row_number ;
2973:
2974: cursor c_get_ra_line_srvtyp(p_vendor_id jai_rcv_tp_invoices.VENDOR_ID%type,p_vendor_site_id jai_rcv_tp_invoices.VENDOR_SITE_ID%type)
2975: is
2976: select service_type_code
2977: from
2978: jai_cmn_vendor_sites