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


VIEW: APPS.POS_BLANKET_AGREE_V

Object Details
Object Name: POS_BLANKET_AGREE_V
Object Type: VIEW
Owner: APPS
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
DESCRIPTION VARCHAR2 (240)
GLOBAL_AGREEMENT_FLAG VARCHAR2 (1)
ACCEPTANCE_DUE_DATE DATE

AMOUNT_LIMIT VARCHAR2 (0)
APPROVED_DATE DATE

START_DATE DATE

END_DATE DATE

AUTHORIZATION_STATUS VARCHAR2 (25)
BLANKET_TOTAL_AMOUNT VARCHAR2 (4000)
MIN_RELEASE_AMOUNT VARCHAR2 (0)
REVISED_DATE DATE

REVISION_NUM NUMBER

AGENT_ID NUMBER (9) Yes
PO_HEADER_ID NUMBER
Yes
VENDOR_CONTACT_ID NUMBER

VENDOR_ID NUMBER

VENDOR_SITE_ID NUMBER

CLOSED_CODE VARCHAR2 (25)
CURRENCY_CODE VARCHAR2 (15)
TYPE_LOOKUP_CODE VARCHAR2 (25) Yes
ACCEPTANCE_REQUIRED_FLAG VARCHAR2 (1)
APPROVED_FLAG VARCHAR2 (1)
CANCEL_FLAG VARCHAR2 (1)
CREATED_BY NUMBER

ORDER_DATE DATE

LAST_UPDATED_BY NUMBER
Yes
LAST_UPDATE_DATE DATE
Yes
LAST_UPDATE_LOGIN NUMBER

PO_NUM VARCHAR2 (20) Yes
ATTRIBUTE_CATEGORY VARCHAR2 (30)
ATTRIBUTE1 VARCHAR2 (150)
ATTRIBUTE2 VARCHAR2 (150)
ATTRIBUTE3 VARCHAR2 (150)
ATTRIBUTE4 VARCHAR2 (150)
ATTRIBUTE5 VARCHAR2 (150)
ATTRIBUTE6 VARCHAR2 (150)
ATTRIBUTE7 VARCHAR2 (150)
ATTRIBUTE8 VARCHAR2 (150)
ATTRIBUTE9 VARCHAR2 (150)
ATTRIBUTE10 VARCHAR2 (150)
ATTRIBUTE11 VARCHAR2 (150)
ATTRIBUTE12 VARCHAR2 (150)
ATTRIBUTE13 VARCHAR2 (150)
ATTRIBUTE14 VARCHAR2 (150)
ATTRIBUTE15 VARCHAR2 (150)
AGENT_NAME VARCHAR2 (4000)
VENDOR_NAME VARCHAR2 (240)
VENDOR_SITE_CODE VARCHAR2 (15) Yes
AUTHORIZATION_STATUS_DSP VARCHAR2 (80) Yes
AMOUNT VARCHAR2 (4000)
ORG_ID NUMBER

ORG_NAME VARCHAR2 (240)
TYPE_NAME VARCHAR2 (4000)
Query Text

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


SELECT DESCRIPTION
,      GLOBAL_AGREEMENT_FLAG
,      ACCEPTANCE_DUE_DATE
,      AMOUNT_LIMIT
,      APPROVED_DATE
,      START_DATE
,      END_DATE
,      AUTHORIZATION_STATUS
,      BLANKET_TOTAL_AMOUNT
,      MIN_RELEASE_AMOUNT
,      REVISED_DATE
,      REVISION_NUM
,      AGENT_ID
,      PO_HEADER_ID
,      VENDOR_CONTACT_ID
,      VENDOR_ID
,      VENDOR_SITE_ID
,      CLOSED_CODE
,      CURRENCY_CODE
,      TYPE_LOOKUP_CODE
,      ACCEPTANCE_REQUIRED_FLAG
,      APPROVED_FLAG
,      CANCEL_FLAG
,      CREATED_BY
,      ORDER_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      PO_NUM
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      AGENT_NAME
,      VENDOR_NAME
,      VENDOR_SITE_CODE
,      AUTHORIZATION_STATUS_DSP
,      AMOUNT
,      ORG_ID
,      ORG_NAME
,      TYPE_NAME
FROM APPS.POS_BLANKET_AGREE_V;

Dependencies

[top of page]

APPS.POS_BLANKET_AGREE_V references the following:

SchemaAPPS
PL/SQL PackageFND_CURRENCY - show dependent code
PL/SQL PackageFND_GLOBAL - show dependent code
PL/SQL PackageFND_MESSAGE - show dependent code
SynonymHR_ALL_ORGANIZATION_UNITS_TL
PL/SQL PackagePOS_GET - show dependent code
PL/SQL PackagePOS_TOTALS_PO_SV - show dependent code
SynonymPO_HEADERS_ARCHIVE_ALL
ViewPO_LOOKUP_CODES
ViewPO_VENDORS
ViewPO_VENDOR_SITES_ALL

APPS.POS_BLANKET_AGREE_V is not referenced by any database object