DBA Data[Home] [Help] [Dependency Information]


VIEW: APPS.PO_ASL_SUPPLIERS_V

Object Details
Object Name: PO_ASL_SUPPLIERS_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewPO.PO_ASL_SUPPLIERS_V
Subobject Name:
Status: VALID

***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

[View Source]

Columns
Name Datatype Length Mandatory Comments
ROW_ID ROWID (10)

ASL_ID NUMBER
Yes
VENDOR_BUSINESS_TYPE_DSP VARCHAR2 (80) Yes
VENDOR_NAME VARCHAR2 (240)

VENDOR_SITE_CODE VARCHAR2 (15)

PRIMARY_VENDOR_ITEM VARCHAR2 (25)

REVIEW_BY_DATE DATE


OWNING_ORGANIZATION_CODE VARCHAR2 (3)

OWNING_ORGANIZATION_NAME VARCHAR2 (240)

USING_ORGANIZATION_CODE VARCHAR2 (3)

USING_ORGANIZATION_NAME VARCHAR2 (240)

GLOBAL_FLAG VARCHAR2 (1)

ASL_STATUS_DSP VARCHAR2 (25) Yes
ITEM_ID NUMBER


COMMODITY_ID NUMBER


VENDOR_ID NUMBER


MANUFACTURER_ID NUMBER


VENDOR_SITE_ID NUMBER


MANUFACTURER_ASL_ID NUMBER


ASL_MANUFACTURER VARCHAR2 (30)

OWNING_ORGANIZATION_ID NUMBER
Yes
USING_ORGANIZATION_ID NUMBER
Yes
ASL_STATUS_ID NUMBER
Yes
VENDOR_BUSINESS_TYPE VARCHAR2 (25) Yes
COMMENTS VARCHAR2 (240)

ATTRIBUTE_CATEGORY VARCHAR2 (30)
Descriptive flexfield structure definition column.
ATTRIBUTE1 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE2 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE3 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE4 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE5 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE6 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE7 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE8 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE9 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE10 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE11 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE12 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE13 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE14 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE15 VARCHAR2 (150)
Descriptive flexfield segment
LAST_UPDATE_LOGIN NUMBER

Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
REQUEST_ID NUMBER

Concurrent Program who column - concurrent request id of the program that last updated this row (foreign key to FND_CONCURRENT_REQUESTS.REQUEST_ID).
PROGRAM_APPLICATION_ID NUMBER

Concurrent Program who column - application id of the program that last updated this row (foreign key to FND_APPLICATION.APPLICATION_ID).
PROGRAM_ID NUMBER

Concurrent Program who column - program id of the program that last updated this row (foreign key to FND_CONCURRENT_PROGRAM.CONCURRENT_PROGRAM_ID).
PROGRAM_UPDATE_DATE DATE

Concurrent Program who column - date when a program last updated this row).
LAST_UPDATE_DATE DATE
Yes Standard Who column - date when a user last updated this row.
LAST_UPDATED_BY NUMBER
Yes Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
CREATION_DATE DATE
Yes Standard who column - date when this row was created.
CREATED_BY NUMBER
Yes Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
DISABLE_FLAG VARCHAR2 (1)
ORG_ID NUMBER

Organization identifier
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT ROW_ID
,      ASL_ID
,      VENDOR_BUSINESS_TYPE_DSP
,      VENDOR_NAME
,      VENDOR_SITE_CODE
,      PRIMARY_VENDOR_ITEM
,      REVIEW_BY_DATE
,      OWNING_ORGANIZATION_CODE
,      OWNING_ORGANIZATION_NAME
,      USING_ORGANIZATION_CODE
,      USING_ORGANIZATION_NAME
,      GLOBAL_FLAG
,      ASL_STATUS_DSP
,      ITEM_ID
,      COMMODITY_ID
,      VENDOR_ID
,      MANUFACTURER_ID
,      VENDOR_SITE_ID
,      MANUFACTURER_ASL_ID
,      ASL_MANUFACTURER
,      OWNING_ORGANIZATION_ID
,      USING_ORGANIZATION_ID
,      ASL_STATUS_ID
,      VENDOR_BUSINESS_TYPE
,      COMMENTS
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      LAST_UPDATE_LOGIN
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      DISABLE_FLAG
,      ORG_ID
FROM APPS.PO_ASL_SUPPLIERS_V;

Dependencies

[top of page]

APPS.PO_ASL_SUPPLIERS_V references the following:

SchemaAPPS
PL/SQL PackageFND_GLOBAL - show dependent code
SynonymHR_ALL_ORGANIZATION_UNITS_TL
PL/SQL PackageHR_GENERAL - show dependent code
ViewHR_ORG_UNITS_NO_JOIN
PL/SQL PackageHR_SECURITY - show dependent code
SynonymMTL_MANUFACTURERS
SynonymMTL_PARAMETERS
SynonymPO_APPROVED_SUPPLIER_LIST
SynonymPO_ASL_ATTRIBUTES
SynonymPO_ASL_STATUSES
ViewPO_LOOKUP_CODES
ViewPO_VENDORS
ViewPO_VENDOR_SITES
APPS.PO_ASL_SUPPLIERS_V is referenced by following:

SchemaAPPS
Package BodyINV_RCV_STD_INSPECT_APIS - show dependent code