DBA Data[Home] [Help]

APPS.PJM_TRANSFER_SPEC_CHARGES_PKG dependencies on PO_DISTRIBUTIONS

Line 21: FROM PO_Distributions POD

17: , POL.Item_Id
18: , POD.Po_Header_Id
19: , Null
20: , Null )
21: FROM PO_Distributions POD
22: , PO_Lines POL
23: WHERE POD.PO_Distribution_Id = X_PO_Distribution_Id
24: AND POL.PO_Line_Id = POD.PO_Line_Id;
25:

Line 34: FROM PO_Distributions POD

30: , wo.standard_operation_id
31: , wdj.wip_entity_id
32: , wdj.primary_item_id
33: , wo.department_id )
34: FROM PO_Distributions POD
35: , WIP_Discrete_Jobs WDJ
36: , WIP_Operations WO
37: WHERE POD.PO_Distribution_Id = X_PO_Distribution_Id
38: AND WO.WIP_Entity_Id = POD.WIP_Entity_Id

Line 239: , PO_Distributions POD

235: and AID.Accounting_Date <= l_End_Date ))
236: AND AID.Invoice_Distribution_Id = ACA.Charge_Dist_Id
237: AND ACA.Item_Dist_Id = AID2.Invoice_Distribution_Id
238: ) DIST
239: , PO_Distributions POD
240: , PA_Projects_ALL PAP
241: WHERE DIST.Invoice_Id = INV.Invoice_Id
242: AND NVL(INV.Source, 'XX' ) <> 'Oracle Project Accounting'
243: AND POD.Destination_Type_Code IN ( 'INVENTORY' , 'SHOP FLOOR' )

Line 342: , PO_Distributions POD

338: and AID.Accounting_Date <= l_End_Date ))
339: AND AID.Invoice_Distribution_Id = ACA.Charge_Dist_Id
340: AND ACA.Item_Dist_Id = AID2.Invoice_Distribution_Id
341: ) DIST
342: , PO_Distributions POD
343: , PA_Projects_ALL PAP
344: , PJM_Org_Parameters POP
345: WHERE DIST.Invoice_Id = INV.Invoice_Id
346: AND NVL(INV.Source, 'XX' ) <> 'Oracle Project Accounting'

Line 450: , PO_Distributions POD

446: and AID.Accounting_Date <= l_End_Date ))
447: AND AID.Invoice_Distribution_Id = ACA.Charge_Dist_Id
448: AND ACA.Item_Dist_Id = AID2.Invoice_Distribution_Id
449: ) DIST
450: , PO_Distributions POD
451: , PA_Projects_ALL PAP
452: WHERE DIST.Invoice_Id = INV.Invoice_Id
453: AND NVL(INV.Source, 'XX' ) <> 'Oracle Project Accounting'
454: AND POD.Destination_Type_Code IN ( 'INVENTORY' , 'SHOP FLOOR' )

Line 552: , PO_Distributions POD

548: and AID.Accounting_Date <= l_End_Date ))
549: AND AID.Invoice_Distribution_Id = ACA.Charge_Dist_Id
550: AND ACA.Item_Dist_Id = AID2.Invoice_Distribution_Id
551: ) DIST
552: , PO_Distributions POD
553: , PA_Projects_ALL PAP
554: , PJM_Org_Parameters POP
555: WHERE DIST.Invoice_Id = INV.Invoice_Id
556: AND NVL(INV.Source, 'XX' ) <> 'Oracle Project Accounting'