GPBR_ACTER_VW

(SQL View)
 Index Back

Accumulators with Co. or Estab

Accumulators with Company or Estabid on user fields

SELECT AC.PIN_NUM , AC.ACM_PRD_OPTN , AC.PIN_USER_KEY1_NUM , AC.PIN_USER_KEY2_NUM , AC.PIN_USER_KEY3_NUM , AC.PIN_USER_KEY4_NUM , AC.PIN_USER_KEY5_NUM , AC.PIN_USER_KEY6_NUM FROM PS_GP_ACCUMULATOR AC , PS_GP_PIN PIN WHERE (AC.PIN_USER_KEY1_NUM IN ( SELECT PIN_NUM FROM PS_GP_PIN WHERE PIN_NM IN ('FP VR COMPANIA', 'FP VR ESTAB')) OR AC.PIN_USER_KEY2_NUM IN ( SELECT PIN_NUM FROM PS_GP_PIN WHERE PIN_NM IN ('FP VR COMPANIA', 'FP VR ESTAB')) OR AC.PIN_USER_KEY3_NUM IN ( SELECT PIN_NUM FROM PS_GP_PIN WHERE PIN_NM IN ('FP VR COMPANIA', 'FP VR ESTAB')) OR AC.PIN_USER_KEY4_NUM IN ( SELECT PIN_NUM FROM PS_GP_PIN WHERE PIN_NM IN ('FP VR COMPANIA', 'FP VR ESTAB')) OR AC.PIN_USER_KEY5_NUM IN ( SELECT PIN_NUM FROM PS_GP_PIN WHERE PIN_NM IN ('FP VR COMPANIA', 'FP VR ESTAB')) OR AC.PIN_USER_KEY6_NUM IN ( SELECT PIN_NUM FROM PS_GP_PIN WHERE PIN_NM IN ('FP VR COMPANIA', 'FP VR ESTAB')) ) AND AC.PIN_NUM = PIN.PIN_NUM AND PIN.COUNTRY = 'BRA'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PIN_NUM Number(8,0) INTEGER NOT NULL PIN Number
2 ACM_PRD_OPTN Character(1) VARCHAR2(1) NOT NULL Accumulator Period
1=Segment
2=Calendar Period
3=Month to Date
4=Quarter to Date
5=Year to Date
6=Custom Period
3 PIN_USER_KEY1_NUM Number(8,0) INTEGER NOT NULL Element number field

Prompt Table: %GP_EDIT_FLD1

4 PIN_USER_KEY2_NUM Number(8,0) INTEGER NOT NULL Element number field

Prompt Table: %GP_EDIT_FLD2

5 PIN_USER_KEY3_NUM Number(8,0) INTEGER NOT NULL Element number field

Prompt Table: %GP_EDIT_FLD3

6 PIN_USER_KEY4_NUM Number(8,0) INTEGER NOT NULL Element number field

Prompt Table: %GP_EDIT_FLD4

7 PIN_USER_KEY5_NUM Number(8,0) INTEGER NOT NULL Element number field

Prompt Table: %GP_EDIT_FLD5

8 PIN_USER_KEY6_NUM Number(8,0) INTEGER NOT NULL Element number field

Prompt Table: %GP_EDIT_FLD6