[Home] [Help]
84: -- Transfer_Spec_Charges_to_PA
85: --
86: -- DESCRIPTION
87: -- This procedure will get the expenditure and costing data for
88: -- Freight, Tax, and other special chargs from AP invoices with
89: -- destination type of INVENTORY or SHOP FLOOR, and push these
90: -- data to PA_TRANSACTION_INTERFACES.
91: --
92: -- PARAMETERS
167: , POD.Po_Distribution_Id Po_Distribution_Id
168: , POD.Destination_Type_Code Destination_Type_Code
169: , DIST.RCV_Transaction_Id RCV_Transaction_Id
170: FROM
171: AP_Invoices INV
172: , (
173: SELECT
174: AID.Invoice_Id
175: , AID.Distribution_Line_Number
270: , POD.Po_Distribution_Id Po_Distribution_Id
271: , POD.Destination_Type_Code Destination_Type_Code
272: , DIST.RCV_Transaction_Id RCV_Transaction_Id
273: FROM
274: AP_Invoices INV
275: , (
276: SELECT
277: AID.Invoice_Id
278: , AID.Distribution_Line_Number
378: , POD.Po_Distribution_Id Po_Distribution_Id
379: , POD.Destination_Type_Code Destination_Type_Code
380: , DIST.RCV_Transaction_Id RCV_Transaction_Id
381: FROM
382: AP_Invoices INV
383: , (
384: SELECT
385: AID.Invoice_Id
386: , AID.Distribution_Line_Number
480: , POD.Po_Distribution_Id Po_Distribution_Id
481: , POD.Destination_Type_Code Destination_Type_Code
482: , DIST.RCV_Transaction_Id RCV_Transaction_Id
483: FROM
484: AP_Invoices INV
485: , (
486: SELECT
487: AID.Invoice_Id
488: , AID.Distribution_Line_Number
862: , SYSDATE
863: , l_user_id
864: FROM
865: AP_Invoice_Distributions DIST
866: , AP_Invoices INV
867: , PA_Tasks TASK
868: , HR_Organization_Units ORG
869: WHERE
870: DIST.Invoice_Id = InvRec.Invoice_Id
1154: , SYSDATE
1155: , l_user_id
1156: FROM
1157: AP_Invoice_Distributions DIST
1158: , AP_Invoices INV
1159: , PA_Tasks TASK
1160: , HR_Organization_Units ORG
1161: WHERE
1162: DIST.Invoice_Id = InvRec.Invoice_Id