SP_BUEXD_NONVW

(SQL View)
Index Back

BU with GST/Excise applicable

This View is modified for India GSTto list business units even when only Sales Tax is applicable for BU as State tax and GST will be referred by same fields

SELECT DISTINCT a.BUSINESS_UNIT , b.DESCRSHORT , b.DESCR FROM PS_BUS_UNIT_TBL_IN a , PS_BUS_UNIT_TBL_FS b , PS_ORG_BU_TAX_APPL c WHERE a.BUSINESS_UNIT=b.BUSINESS_UNIT AND a.BUSINESS_UNIT=c.BUSINESS_UNIT AND a.BU_STATUS='1' AND c.ORG_BU_TYPE='IN' AND ( c.EXD_OTC_APPL='Y' OR c.STX_OTC_APPL = 'Y')

  • Related Language Record: SP_BUEXD_NOLVW
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
    2 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description
    3 DESCR Character(30) VARCHAR2(30) NOT NULL Description