BUSINESS_UNITDefault Value: PROJECT.BUSINESS_UNIT
Prompt Table: SP_BU_PC_NONVW
CONTRACT_NUMNAME1CONTRACT_LINE_NUMCONTRACT_TYPEBUSINESS_UNIT_PCPROJECT_IDPrompt Table: SP_PROJ_NONVW
LANGUAGE_CDCA_PRACT_VW_LG(SQL View) |
Index Back |
|---|---|
Project Activities |
| SELECT HDR.BUSINESS_UNIT ,DTL_PROJ.CONTRACT_NUM ,SOLD.NAME1 ,DTL_PROJ.CONTRACT_LINE_NUM ,HDR.CONTRACT_TYPE ,DTL_PROJ.BUSINESS_UNIT_PC ,DTL_PROJ.PROJECT_ID ,LANG.LANGUAGE_CD ,DTL.DESCR ,PROJ.DESCR ,CA_TYPE.DESCR FROM PS_CA_DETAIL_PROJ DTL_PROJ ,PS_CA_CONTR_HDR HDR ,PS_CUST_SLD_VW SOLD ,PS_CA_DETAIL DTL ,PS_PROJECT PROJ ,PS_PROJECT_STATUS STATUS ,PS_CA_TYPE_TBL CA_TYPE ,PS_CA_DETAIL_LANG LANG WHERE DTL_PROJ.CONTRACT_NUM = HDR.CONTRACT_NUM AND SOLD.CUST_ID = HDR.SOLD_TO_CUST_ID AND CA_TYPE.CONTRACT_TYPE = HDR.CONTRACT_TYPE AND HDR.CONTRACT_NUM = DTL.CONTRACT_NUM AND DTL_PROJ .CONTRACT_LINE_NUM = DTL.CONTRACT_LINE_NUM AND PROJ.BUSINESS_UNIT = STATUS.BUSINESS_UNIT AND PROJ.PROJECT_ID = STATUS.PROJECT_ID AND DTL_PROJ.BUSINESS_UNIT_PC = PROJ.BUSINESS_UNIT AND DTL_PROJ.PROJECT_ID = PROJ.PROJECT_ID AND STATUS.EFFDT = ( SELECT MAX(A.EFFDT) FROM PS_PROJECT_STATUS A WHERE STATUS.BUSINESS_UNIT = A.BUSINESS_UNIT AND STATUS.PROJECT_ID = A.PROJECT_ID) AND STATUS.EFFSEQ = ( SELECT MAX(B.EFFSEQ) FROM PS_PROJECT_STATUS B WHERE STATUS.BUSINESS_UNIT = B.BUSINESS_UNIT AND STATUS.PROJECT_ID = B.PROJECT_ID AND STATUS.EFFDT = B.EFFDT) AND %Join(COMMON_KEYS, CA_DETAIL DTL, CA_DETAIL_LANG LANG) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Default Value: PROJECT.BUSINESS_UNIT Prompt Table: SP_BU_PC_NONVW |
| 2 | CONTRACT_NUM |
Character(25) | VARCHAR2(25) NOT NULL | Contract |
| 3 | NAME1 |
Character(40) | VARCHAR2(40) NOT NULL | Name 1 |
| 4 | CONTRACT_LINE_NUM |
Number(3,0) | SMALLINT NOT NULL | Contract Line Num |
| 5 | CONTRACT_TYPE |
Character(15) | VARCHAR2(15) NOT NULL | Contract Type |
| 6 | BUSINESS_UNIT_PC |
Character(5) | VARCHAR2(5) NOT NULL | PC Business Unit |
| 7 | PROJECT_ID |
Character(15) | VARCHAR2(15) NOT NULL |
Project Id ChartField
Prompt Table: SP_PROJ_NONVW |
| 8 | LANGUAGE_CD |
Character(3) | VARCHAR2(3) NOT NULL | Language Code |
| 9 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 10 | DESCR1 | Character(30) | VARCHAR2(30) NOT NULL | Descr |
| 11 | DESCR2 | Character(30) | VARCHAR2(30) NOT NULL | Descr2 |