[Home] [Help]
View: MRP_AP_PROJECTS_V
Product: | MRP - Master Scheduling/MRP |
Description: | |
Implementation/DBA Data: |
Not implemented in this database
|
View Text
SELECT PPP.PROJECT_ID
, PPP.ORGANIZATION_ID
, PPP.PLANNING_GROUP
, PPP.COSTING_GROUP_ID
, PPP.WIP_ACCT_CLASS_CODE
, PPP.SEIBAN_NUMBER_FLAG
, PPA.NAME PROJECT_NAME
, PPA.PROJECT_NUMBER
, PPA.DESCRIPTION PROJECT_DESCRIPTION
, PPA.START_DATE
, PPA.COMPLETION_DATE
, PPA.RN RN3
, PPP.RN RN2
, MP.RN RN1
FROM MRP_AP_MRP_PARAS_SN MP
, MRP_AP_PRJ_ALL_SN PPA
, MRP_AP_PRJ_PARAS_SN PPP
WHERE PPA.PROJECT_ID= PPP.PROJECT_ID
AND PPP.ORGANIZATION_ID= MP.ORGANIZATION_ID
Columns
Name |
PROJECT_ID |
ORGANIZATION_ID |
PLANNING_GROUP |
COSTING_GROUP_ID |
WIP_ACCT_CLASS_CODE |
SEIBAN_NUMBER_FLAG |
PROJECT_NAME |
PROJECT_NUMBER |
PROJECT_DESCRIPTION |
START_DATE |
COMPLETION_DATE |
RN3 |
RN2 |
RN1 |