AP_MEC_ADHGP_VW

(SQL View)
 Index Back

AP MECC Adhoc Group

AP MECC Adhoc Group Prompt View

SELECT A.AP_MTCH_EXCP_GRP , ' ' , A.DESCR50 , ' ' , ' ' , ' ' FROM PS_AP_MTCH_EX_GRP A WHERE A.EFF_STATUS = 'A' AND A.MTCH_EX_APBU_OPT = 'Y' AND A.MTCH_EX_POBU_OPT = 'Y' AND A.MTCH_EX_SHIP_OPT = 'Y' UNION SELECT A.AP_MTCH_EXCP_GRP ,'AP' , A.DESCR50 , APBU.BUSINESS_UNIT_AP , ' ' , ' ' FROM PS_AP_MTCH_EX_GRP A , PS_AP_MTCH_GRPAPBU APBU WHERE A.EFF_STATUS = 'A' AND A.MTCH_EX_APBU_OPT = 'N' AND A.AP_MTCH_EXCP_GRP = APBU.AP_MTCH_EXCP_GRP UNION SELECT A.AP_MTCH_EXCP_GRP , 'PO' , A.DESCR50 , POBU.BUSINESS_UNIT_PO , ' ' , ' ' FROM PS_AP_MTCH_EX_GRP A , PS_AP_MTCH_GRPPOBU POBU WHERE A.EFF_STATUS = 'A' AND A.MTCH_EX_POBU_OPT = 'N' AND A.AP_MTCH_EXCP_GRP = POBU.AP_MTCH_EXCP_GRP UNION SELECT A.AP_MTCH_EXCP_GRP , 'ST' , A.DESCR50 , ' ' , SETID , SHIPTO_ID FROM PS_AP_MTCH_EX_GRP A , PS_AP_MTCH_GRPSHIP POST WHERE A.EFF_STATUS = 'A' AND A.MTCH_EX_SHIP_OPT = 'N' AND A.AP_MTCH_EXCP_GRP = POST.AP_MTCH_EXCP_GRP

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 AP_MTCH_EXCP_GRP Character(18) VARCHAR2(18) NOT NULL Match Exception Group
2 WHERE_TYPE Character(2) VARCHAR2(2) NOT NULL An internal work field that indicates whether user defined position tree SQL criteria is utilized for either p
01=Bin Impact
02=Deal Conditions
3 DESCR50 Character(50) VARCHAR2(50) NOT NULL Description of length 50
4 BUSINESS_UNIT_1 Character(5) VARCHAR2(5) NOT NULL Non-Joint Venture BU
5 SETID1 Character(5) VARCHAR2(5) NOT NULL SetID Value
6 SHIPTO_ID2 Character(10) VARCHAR2(10) NOT NULL SHIP TO LOCATION