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