DBA Data[Home] [Help]

APPS.JAI_TRX_REPO_EXTRACT_PKG dependencies on JAI_RCV_TP_INVOICES

Line 1567: jai_rcv_tp_invoices jrti,

1563: row_number() over(
1564: ORDER BY jrtxl.shipment_line_id,jrtxl.tax_line_no) rn
1565: FROM jai_rcv_lines jrt,
1566: rcv_transactions jirt,
1567: jai_rcv_tp_invoices jrti,
1568: jai_rcv_line_taxes jrtxl -- join to ja_in_receipt_tax_lines added by vumaasha for 6856213
1569: WHERE jrt.shipment_header_id = jrti.shipment_header_id
1570: AND jrti.invoice_id = p_invoice_id
1571: AND jrti.shipment_header_id = jirt.shipment_header_id

Line 1579: 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)

1575: AND jrtxl.shipment_header_id = jrti.shipment_header_id
1576: AND jirt.shipment_line_id = jrtxl.shipment_line_id)
1577: WHERE rn =p_row_number ;
1578:
1579: 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)
1580: is
1581: select service_type_code
1582: from
1583: jai_cmn_vendor_sites