CM_LOC_ACCTG_VW

(SQL View)
 Index Back

Location Acctg View

07/99 GMG CN800-9.0: Location Accounting flag by business unit

SELECT PS_BUS_UNIT_TBL_IN.BUSINESS_UNIT , PS_BU_ATTRIB_INV.SETID , PS_BU_ATTRIB_INV.LOC_ACCTG_REQ , PS_BU_ATTRIB_INV.FERC_CD_FLAG FROM PS_BUS_UNIT_TBL_IN , PS_BU_ATTRIB_INV , PS_SET_CNTRL_REC WHERE PS_SET_CNTRL_REC.RECNAME = 'BU_ATTRIB_INV' AND PS_SET_CNTRL_REC.SETCNTRLVALUE = PS_BUS_UNIT_TBL_IN.BUSINESS_UNIT AND PS_SET_CNTRL_REC.SETID = PS_BU_ATTRIB_INV.SETID AND PS_BU_ATTRIB_INV.EFF_STATUS = 'A' AND PS_BU_ATTRIB_INV.EFFDT = ( SELECT MAX(EFFDT) FROM PS_BU_ATTRIB_INV WHERE PS_SET_CNTRL_REC.RECNAME = 'BU_ATTRIB_INV' AND PS_SET_CNTRL_REC.SETCNTRLVALUE = PS_BUS_UNIT_TBL_IN.BUSINESS_UNIT AND PS_SET_CNTRL_REC.SETID = PS_BU_ATTRIB_INV.SETID AND PS_BU_ATTRIB_INV.EFF_STATUS = 'A' AND PS_BU_ATTRIB_INV.EFFDT <= %CurrentDateIn)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
2 SETID Character(5) VARCHAR2(5) NOT NULL SetID

Default Value: OPR_DEF_TBL_FS.SETID

Prompt Table: SP_SETID_NONVW

3 LOC_ACCTG_REQ Character(1) VARCHAR2(1) NOT NULL Location Accounting Required
4 FERC_CD_FLAG Character(1) VARCHAR2(1) NOT NULL FERC Reporting

Y/N Table Edit

Default Value: N