Link Between PA Project All and GL Headers : pa_cost_distribution_lines_all gl_je_lines

Link Between PA Project All and GL Headers : pa_cost_distribution_lines_all gl_je_lines

In this post , we will be discuss about the SQL DB link between projects and the General ledgers in oracle apps. This post , will help to find the link between PA Project All and GL Headers. The most important table which do helps to join these two table is pa_cost_distribution_lines_all . This table directly join with the GL_JE_LINES tables. With the help of this table we can join the Project and General Ledger accounting tables in oracle apps. Here below is the complete Information about Link Between PA Project All and GL Headers using pa_cost_distribution_lines_all gl_je_lines.

Important Tables to Link Between PA Project All and GL Headers

PA_COST_DISTRIBUTION_LINES_ALL

PA_CUST_EVENT_RDL_ALL

PA_CUST_REV_DIST_LINES_ALL

The following Projects tables have reference fields in the General Ledger table GL_JE_LINES:

1. Tables
   
   • PA_COST_DISTRIBUTION_LINES_ALL
   • PA_CUST_EVENT_RDL_ALL
   • PA_CUST_REV_DIST_LINES_ALL

1. All have reference fields in GL_JE_LINES.  The join conditions with these columns are:

1. BATCH_NAME             = GL_JE_LINES.REFERENCE_1
   DR_CODE_COMBINATION_ID = GL_JE_LINES.CODE_COMBINATION_ID
2. The PA_DRAFT_REVENUES_ALL table has the following join conditions
3. UNEARNED_BATCH_NAME          = GL_JE_LINES.REFERENCE_1
4. UNEARNED_CODE_COMBINATION_ID = GL_JE_LINES.CODE_COMBINATION_ID
   
   or
   
   
   UNBILLED_BATCH_NAME          = GL_JE_LINES.REFERENCE_1
   UNBILLED_CODE_COMBINATION_ID = GL_JE_LINES.CODE_COMBINATION_ID