DBA Data[Home] [Help]

APPS.JAI_AP_ILA_TRIGGER_PKG dependencies on RCV_SHIPMENT_LINES

Line 127: FROM Rcv_Shipment_Lines

123: );
124:
125: CURSOR Fetch_Shipment_Line_Id_Cur( invorg IN NUMBER, receiptnum IN VARCHAR2 ) IS
126: SELECT Shipment_Line_Id, Shipment_Header_Id
127: FROM Rcv_Shipment_Lines
128: WHERE Shipment_Header_Id IN ( SELECT Shipment_Header_Id
129: FROM Rcv_Shipment_Headers
130: WHERE Receipt_Num = receiptnum )
131: AND Po_Line_location_Id = ( SELECT Line_Location_Id

Line 138: FROM Rcv_Shipment_Lines

134: AND To_Organization_Id = invorg;
135:
136: CURSOR Fetch_Shipment_Count_Cur( invorg IN NUMBER ) IS
137: SELECT COUNT( Shipment_Line_Id )
138: FROM Rcv_Shipment_Lines
139: WHERE Shipment_Header_Id = v_shipment_header_id
140: AND To_Organization_Id = invorg;
141:
142: ------------Packing Slip---------------------