PO_SS_ASNOHD_LG(SQL View) |
Index Back |
---|---|
Sup Portal: ASN History VwLang |
SELECT C.EIP_CTL_ID , D.LANGUAGE_CD , D.SHIP_TYPE_ID FROM PS_RECV_AOHD_EC C , PS_RECV_ASHD_EC B , PS_EO_EIP_CTL A , PS_RECV_ASHD_LANG D WHERE A.EIP_CTL_ID = B.EIP_CTL_ID AND B.EIP_CTL_ID = C.EIP_CTL_ID AND B.EIP_CTL_ID = D.EIP_CTL_ID |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | EIP_CTL_ID | Character(25) | VARCHAR2(25) NOT NULL | Enterprise Components EIP (enterprise integration point) control field |
2 | LANGUAGE_CD | Character(3) | VARCHAR2(3) NOT NULL | Language Code |
3 | SHIP_TYPE_ID | Character(10) | VARCHAR2(10) NOT NULL | Ship Via Code |