DBA Data[Home] [Help]

APPS.JAI_AP_ILA_TRIGGER_PKG dependencies on RCV_SHIPMENT_LINES

Line 99: FROM Rcv_Shipment_Lines

95: );
96:
97: CURSOR Fetch_Shipment_Line_Id_Cur( invorg IN NUMBER, receiptnum IN VARCHAR2 ) IS
98: SELECT Shipment_Line_Id, Shipment_Header_Id
99: FROM Rcv_Shipment_Lines
100: WHERE Shipment_Header_Id IN ( SELECT Shipment_Header_Id
101: FROM Rcv_Shipment_Headers
102: WHERE Receipt_Num = receiptnum )
103: AND Po_Line_location_Id = ( SELECT Line_Location_Id

Line 110: FROM Rcv_Shipment_Lines

106: AND To_Organization_Id = invorg;
107:
108: CURSOR Fetch_Shipment_Count_Cur( invorg IN NUMBER ) IS
109: SELECT COUNT( Shipment_Line_Id )
110: FROM Rcv_Shipment_Lines
111: WHERE Shipment_Header_Id = v_shipment_header_id
112: AND To_Organization_Id = invorg;
113:
114: ------------Packing Slip---------------------