DBA Data[Home] [Help]

APPS.JAI_AP_ILA_TRIGGER_PKG dependencies on PO_DISTRIBUTIONS_ALL

Line 120: FROM Po_Distributions_All

116: FROM Hr_Locations
117: WHERE Location_Id = ( SELECT Ship_To_Location_Id
118: FROM Po_Headers_All
119: WHERE Po_Header_Id = ( SELECT Po_Header_Id
120: FROM Po_Distributions_All
121: WHERE Po_Distribution_Id = pr_new.Po_Distribution_Id
122: )
123: );
124:

Line 132: FROM Po_Distributions_All

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
132: FROM Po_Distributions_All
133: WHERE Po_Distribution_Id = pr_new.Po_Distribution_Id )
134: AND To_Organization_Id = invorg;
135:
136: CURSOR Fetch_Shipment_Count_Cur( invorg IN NUMBER ) IS