DBA Data[Home] [Help]

APPS.JAI_AP_MATCH_TAX_PROC_PKG dependencies on RCV_SHIPMENT_LINES

Line 1581: FROM Rcv_Shipment_Lines

1577: WHERE code_combination_id = pr_ap_inv_dist_item.dist_code_combination_id;
1578:
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

Line 3112: FROM Rcv_Shipment_Lines

3108: )
3109: );
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

Line 3123: FROM Rcv_Shipment_Lines

3119: AND To_Organization_Id = invorg;
3120:
3121: CURSOR Fetch_Shipment_Count_Cur( invorg IN NUMBER,v_shipment_header_id NUMBER ) IS
3122: SELECT COUNT( Shipment_Line_Id )
3123: FROM Rcv_Shipment_Lines
3124: WHERE Shipment_Header_Id = v_shipment_header_id
3125: AND To_Organization_Id = invorg;
3126:
3127: r_ap_inv_line_item ap_invoice_lines_all%ROWTYPE;