Saturday, 26 September 2015

Join between PA_EXPEND_ITEMS_ADJUST2_V , PA_COST_DIST_LINES_V, PA_PROJECTS_ALL



SELECT * FROM
FROM  PA_EXPEND_ITEMS_ADJUST2_V PEI,
 PA_COST_DIST_LINES_V PCD,
 GL_CODE_COMBINATIONS GCC,
 PA_PROJECTS_ALL PPA
WHERE PEI.EXPENDITURE_ITEM_ID=PCD.EXPENDITURE_ITEM_ID
AND   PCD.DR_CODE_COMBINATION_ID=GCC.CODE_COMBINATION_ID
AND   (PEI.TRANSACTION_SOURCE IS NULL OR PEI.TRANSACTION_SOURCE='AP INVOICE')
AND   PEI.PROJECT_ID=PPA.PROJECT_ID
--AND   PEI.PROJECT_NUMBER BETWEEN DECODE(:PA_SEGMENT1,'ALL',PEI.PROJECT_NUMBER,:PA_SEGMENT1) AND DECODE(:PA_SEGMENT1_1,'ALL',PEI.PROJECT_NUMBER,:PA_SEGMENT1_1)
--AND   TRUNC(PEI.CREATION_DATE) BETWEEN NVL(:P_FROM_DATE,TRUNC(PEI.CREATION_DATE)) AND NVL(:P_TO_DATE,TRUNC(PEI.CREATION_DATE))

No comments:

Post a Comment