APPS.JAI_AP_MATCH_TAX_PROC_PKG dependencies on RCV_SHIPMENT_HEADERS

Line 1583: FROM Rcv_Shipment_Headers

1579: CURSOR Fetch_Shipment_Line_Id_Cur( invorg IN NUMBER, receiptnum IN VARCHAR2 ) IS
1580: SELECT Shipment_Line_Id, Shipment_Header_Id
1581: FROM Rcv_Shipment_Lines
1582: WHERE Shipment_Header_Id IN ( SELECT Shipment_Header_Id
1583: FROM Rcv_Shipment_Headers
1584: WHERE Receipt_Num = receiptnum )
1585: AND Po_Line_location_Id = ( SELECT Line_Location_Id
1586: FROM Po_Distributions_All
1587: WHERE Po_Distribution_Id = pr_ap_inv_line_item.po_line_location_id)

Line 3087: FROM rcv_shipment_headers rsh, rcv_transactions rt

3083: WHERE invoice_id = pn_invoice_id;
3084:
3085: CURSOR count_receipts(p_pck_slip VARCHAR2, ven_id NUMBER, cpv_transaction_type VARCHAR2 ) IS
3086: SELECT DISTINCT rsh.receipt_num, rsh.shipment_header_id
3087: FROM rcv_shipment_headers rsh, rcv_transactions rt
3088: WHERE rsh.shipment_header_id = rt.shipment_header_id
3089: AND rsh.packing_slip = p_pck_slip
3090: AND rsh.vendor_id = ven_id
3091: AND rt.transaction_type = cpv_transaction_type;

Line 3114: FROM Rcv_Shipment_Headers

3110: CURSOR Fetch_Shipment_Line_Id_Cur( invorg IN NUMBER, receiptnum IN VARCHAR2 ,c_po_dist_id NUMBER) IS
3111: SELECT Shipment_Line_Id, Shipment_Header_Id
3112: FROM Rcv_Shipment_Lines
3113: WHERE Shipment_Header_Id IN ( SELECT Shipment_Header_Id
3114: FROM Rcv_Shipment_Headers
3115: WHERE Receipt_Num = receiptnum )
3116: AND Po_Line_location_Id = ( SELECT Line_Location_Id
3117: FROM Po_Distributions_All
3118: WHERE Po_Distribution_Id = c_po_dist_id)

Line 3132: v_receipt_num RCV_SHIPMENT_HEADERS.RECEIPT_NUM%TYPE;

3128: count_receipts_rec count_receipts%ROWTYPE;
3129: vend_info_rec vend_info%ROWTYPE;
3130: fetch_rcv_record_rec fetch_rcv_record%ROWTYPE;
3131: set_up_info_rec set_up_info%ROWTYPE;
3132: v_receipt_num RCV_SHIPMENT_HEADERS.RECEIPT_NUM%TYPE;
3133: v_source ap_invoices_all.SOURCE%TYPE;
3134:
3135: v_inv_org_id NUMBER;
3136: v_count_tax_dist NUMBER;