[Home] [Help] [Dependency Information]
Object Name: | PO_SUPPLIER_USERS_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | PO.PO_SUPPLIER_USERS_V |
Subobject Name: | |
Status: | VALID |
Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.
Internal
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
FND_USER_ID | NUMBER | (15) | Yes | Login User ID |
FND_USER_NAME | VARCHAR2 | (100) | Yes | Login User Name |
FND_CUSTOMER_ID | NUMBER | (15) | Customer Id | |
USER_PARTY_ID | NUMBER | (15) | Yes | User Party Id |
USER_PARTY_NAME | VARCHAR2 | (360) | Yes | User party name |
USER_PARTY_FULL_NAME | VARCHAR2 | (362) | User Party full name | |
USER_PARTY_EMAIL_ADDRESS | VARCHAR2 | (2000) | Party email address | |
USER_PARTY_CITY | VARCHAR2 | (60) | Party Address :City | |
USER_PARTY_STATE | VARCHAR2 | (60) | Party Address : state | |
USER_PARTY_PROVINCE | VARCHAR2 | (60) | Party Address :Province | |
VENDOR_PARTY_ID | NUMBER | (15) | Yes | Vendor Party Id |
PO_VENDOR_NAME | VARCHAR2 | (240) | Vendor Name corresponding to PO_VENDORS | |
PO_VENDOR_ID | NUMBER | Yes | Vendor id corresponding to PO_VENDORS |
Cut, paste (and edit) the following text to query this object:
SELECT FND_USER_ID
, FND_USER_NAME
, FND_CUSTOMER_ID
, USER_PARTY_ID
, USER_PARTY_NAME
, USER_PARTY_FULL_NAME
, USER_PARTY_EMAIL_ADDRESS
, USER_PARTY_CITY
, USER_PARTY_STATE
, USER_PARTY_PROVINCE
, VENDOR_PARTY_ID
, PO_VENDOR_NAME
, PO_VENDOR_ID
FROM APPS.PO_SUPPLIER_USERS_V;
|
|
|