SP_BUEXD_NONVW(SQL View) |
Index Back |
---|---|
BU with GST/Excise applicableThis 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') |
# | 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 |