DBA Data[Home] [Help]

APPS.PJM_TRANSFER_SPEC_CHARGES_PKG dependencies on PA_PROJECTS_ALL

Line 240: , PA_Projects_ALL PAP

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' )
244: AND PAP.Project_Id = POD.Project_Id

Line 343: , PA_Projects_ALL PAP

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'
347: AND POD.Destination_Type_Code IN ( 'INVENTORY' , 'SHOP FLOOR' )

Line 451: , PA_Projects_ALL PAP

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' )
455: AND PAP.Project_Id = POD.Project_Id

Line 553: , PA_Projects_ALL PAP

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'
557: AND POD.Destination_Type_Code IN ( 'INVENTORY' , 'SHOP FLOOR' )