KK_INQ_LDCRI_VW(SQL View) |
Index Back |
|---|---|
KK Inqruiry Ledger |
| SELECT A.OPRID , A.INQUIRY , A.DESCR40 , A.BUSINESS_UNIT , A.LEDGER_GROUP , B.LEDGER , A.KK_INQ_CAL_TYPE , D.CALENDAR_ID , A.PER_SORT_NUM FROM PS_KK_INQ_LD_CRIT A , PS_LED_GRP_LED_TBL B , PS_SET_CNTRL_GROUP C , PS_KK_INQ_LDTS_TMP D WHERE A.LEDGER_INQUIRY_SET = ' ' AND B.LEDGER_GROUP = A.LEDGER_GROUP AND B.SETID = C.SETID AND C.SETCNTRLVALUE = A.BUSINESS_UNIT AND C.REC_GROUP_ID = 'FS_04' AND D.OPRID = A.OPRID AND D.INQUIRY = A.INQUIRY AND B.LEDGER_GROUP = A.LEDGER_GROUP UNION SELECT DISTINCT A.OPRID , A.INQUIRY , A.DESCR40 , A.BUSINESS_UNIT , B.LEDGER_GROUP , B.LEDGER , A.KK_INQ_CAL_TYPE , C.CALENDAR_ID , A.PER_SORT_NUM FROM PS_KK_INQ_LD_CRIT A , PS_LED_INQ_SET_LED B , PS_KK_INQ_LDTS_TMP C WHERE A.LEDGER_INQUIRY_SET <> ' ' AND B.BUSINESS_UNIT = A.BUSINESS_UNIT AND B.LEDGER_INQUIRY_SET = A.LEDGER_INQUIRY_SET AND C.OPRID = A.OPRID AND C.INQUIRY = A.INQUIRY AND B.LEDGER_GROUP = C.LEDGER_GROUP AND C.SELECT_ROW_FLAG = 'Y' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  OPRID |
Character(30) | VARCHAR2(30) NOT NULL |
A user's ID (see PSOPRDEFN).
Prompt Table: OPRID_VW |
| 2 | INQUIRY |
Character(10) | VARCHAR2(10) NOT NULL | Inquiry Name |
| 3 | DESCR40 | Character(40) | VARCHAR2(40) NOT NULL | Description |
| 4 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT Prompt Table: SP_BU_GL_NONVW |
| 5 | LEDGER_GROUP | Character(10) | VARCHAR2(10) NOT NULL |
Ledger Group
Prompt Table: SP_LGRPKK_NONVW |
| 6 | LEDGER | Character(10) | VARCHAR2(10) NOT NULL | Ledger |
| 7 | KK_INQ_CAL_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Type of Calendar
D=Detail Accounting Period I=Summary Budget Period P=Detail Budget Period S=Summary Accounting Period Default Value: P |
| 8 | CALENDAR_ID | Character(2) | VARCHAR2(2) NOT NULL | Calendar ID |
| 9 | PER_SORT_NUM | Number(2,0) | SMALLINT NOT NULL | Period Sort Order Number |