Join Between pa_projects_all and gl_code_combinations

Join Between pa_projects_all and gl_code_combinations

In this post , we will be discuss about the pa_projects_all and gl_code_combinations tables joins. pa_projects_all helps to store the Oracle project related information's in oracle apps and gl_code_combinations table helps to the chart of account code combination information in oracle apps. If we want to extract the GL code combination used in the Oracle project then we need the join between pa_projects_all and gl_code_combinations. There is no direct join or link between these two tables. We need to involve other tables for creating link or join between pa_projects_all and gl_code_combinations.

 

Important table for creating Join Between pa_projects_all and gl_code_combinations

1.PA_EXPEND_ITEMS_ADJUST2_V PEI,
2.PA_COST_DIST_LINES_V PCD,
3.GL_CODE_COMBINATIONS GCC,
4.PA_PROJECTS_ALL PPA

 

 

Details SQL query using the Join Between pa_projects_all and gl_code_combinations

 

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.PROJECT_ID=PPA.PROJECT_ID
AND 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