88: FROM Hr_Locations
89: WHERE Location_Id = ( SELECT Ship_To_Location_Id
90: FROM Po_Headers_All
91: WHERE Po_Header_Id = ( SELECT Po_Header_Id
92: FROM Po_Distributions_All
93: WHERE Po_Distribution_Id = pr_new.Po_Distribution_Id
94: )
95: );
96:
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
104: FROM Po_Distributions_All
105: WHERE Po_Distribution_Id = pr_new.Po_Distribution_Id )
106: AND To_Organization_Id = invorg;
107:
108: CURSOR Fetch_Shipment_Count_Cur( invorg IN NUMBER ) IS