DBA Data[Home] [Help]

APPS.JAI_AP_ILA_TRIGGER_PKG dependencies on PO_DISTRIBUTIONS_ALL

Line 92: FROM Po_Distributions_All

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:

Line 104: FROM Po_Distributions_All

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