eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

VIEW: APPS.AP_PO_DETAILS_V

Object Details

Object Name:	AP_PO_DETAILS_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	SQLAP.AP_PO_DETAILS_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
PO_HEADER_ID	NUMBER		Yes	Document header unique identifier
POH_TYPE_LOOKUP_CODE	VARCHAR2	(25)	Yes	Type of the document. (Combined with segment1and org_id to form unique key; References PO_DOCUMENT_TYPES_ALL_B.document_subtype)
PO_NUMBER	VARCHAR2	(20)	Yes	Document number - Combined with type_lookup_code and org_id to form unique key
POH_SEGMENT2	VARCHAR2	(20)		Key Flexfield segment column
POH_SEGMENT3	VARCHAR2	(20)		Key Flexfield segment column
POH_SEGMENT4	VARCHAR2	(20)		Key Flexfield segment column
POH_SEGMENT5	VARCHAR2	(20)		Key Flexfield segment column
POH_STATUS_LOOKUP_CODE	VARCHAR2	(25)		Status of the RFQ or Quotation (References PO_LOOKUP_CODES.lookup_code with LOOKUP_TYPE='RFQ/QUOTE STATUS')
POH_CURRENCY_CODE	VARCHAR2	(15)		Unique identifier for the currency (References FND_CURRENCIES.currency_code)
POH_ATTRIBUTE_CATEGORY	VARCHAR2	(30)		Descriptive flexfield segment
POH_ATTRIBUTE1	VARCHAR2	(150)		Descriptive flexfield segment
POH_ATTRIBUTE2	VARCHAR2	(150)		Descriptive flexfield segment
POH_ATTRIBUTE3	VARCHAR2	(150)		Descriptive flexfield segment
POH_ATTRIBUTE4	VARCHAR2	(150)		Descriptive flexfield segment
POH_ATTRIBUTE5	VARCHAR2	(150)		Descriptive flexfield segment
POH_ATTRIBUTE6	VARCHAR2	(150)		Descriptive flexfield segment
POH_ATTRIBUTE7	VARCHAR2	(150)		Descriptive flexfield segment
POH_ATTRIBUTE8	VARCHAR2	(150)		Descriptive flexfield segment
POH_ATTRIBUTE9	VARCHAR2	(150)		Descriptive flexfield segment
POH_ATTRIBUTE10	VARCHAR2	(150)		Descriptive flexfield segment
POH_ATTRIBUTE11	VARCHAR2	(150)		Descriptive flexfield segment
POH_ATTRIBUTE12	VARCHAR2	(150)		Descriptive flexfield segment
POH_ATTRIBUTE13	VARCHAR2	(150)		Descriptive flexfield segment
POH_ATTRIBUTE14	VARCHAR2	(150)		Descriptive flexfield segment
POH_ATTRIBUTE15	VARCHAR2	(150)		Descriptive flexfield segment
POH_GLOBAL_ATTRIBUTE_CATEGORY	VARCHAR2	(150)		Reserved for country-specific functionality
POH_GLOBAL_ATTRIBUTE1	VARCHAR2	(150)		Reserved for country-specific functionality
POH_GLOBAL_ATTRIBUTE2	VARCHAR2	(150)		Reserved for country-specific functionality
POH_GLOBAL_ATTRIBUTE3	VARCHAR2	(150)		Reserved for country-specific functionality
POH_GLOBAL_ATTRIBUTE4	VARCHAR2	(150)		Reserved for country-specific functionality
POH_GLOBAL_ATTRIBUTE5	VARCHAR2	(150)		Reserved for country-specific functionality
POH_GLOBAL_ATTRIBUTE6	VARCHAR2	(150)		Reserved for country-specific functionality
POH_GLOBAL_ATTRIBUTE7	VARCHAR2	(150)		Reserved for country-specific functionality
POH_GLOBAL_ATTRIBUTE8	VARCHAR2	(150)		Reserved for country-specific functionality
POH_GLOBAL_ATTRIBUTE9	VARCHAR2	(150)		Reserved for country-specific functionality
POH_GLOBAL_ATTRIBUTE10	VARCHAR2	(150)		Reserved for country-specific functionality
POH_GLOBAL_ATTRIBUTE11	VARCHAR2	(150)		Reserved for country-specific functionality
POH_GLOBAL_ATTRIBUTE12	VARCHAR2	(150)		Reserved for country-specific functionality
POH_GLOBAL_ATTRIBUTE13	VARCHAR2	(150)		Reserved for country-specific functionality
POH_GLOBAL_ATTRIBUTE14	VARCHAR2	(150)		Reserved for country-specific functionality
POH_GLOBAL_ATTRIBUTE15	VARCHAR2	(150)		Reserved for country-specific functionality
POH_GLOBAL_ATTRIBUTE16	VARCHAR2	(150)		Reserved for country-specific functionality
POH_GLOBAL_ATTRIBUTE17	VARCHAR2	(150)		Reserved for country-specific functionality
POH_GLOBAL_ATTRIBUTE18	VARCHAR2	(150)		Reserved for country-specific functionality
POH_GLOBAL_ATTRIBUTE19	VARCHAR2	(150)		Reserved for country-specific functionality
POH_GLOBAL_ATTRIBUTE20	VARCHAR2	(150)		Reserved for country-specific functionality
POH_REFERENCE_NUM	VARCHAR2	(25)		Audit trail reference (needed for 832 EDI transaction)
PO_LINE_ID	NUMBER		Yes	Document line unique identifier
POL_LINE_TYPE_ID	NUMBER			Line type unique identifier (References PO_LINE_TYPES_B.line_type_id.)
POL_LINE_NUM	NUMBER		Yes	Line number
POL_ITEM_DESCRIPTION	VARCHAR2	(240)		Item description. (Defaulted from MTL_SYSTEM_ITEMS_TL.description.)
POL_ATTRIBUTE_CATEGORY	VARCHAR2	(30)		Descriptive flexfield segment
POL_ATTRIBUTE1	VARCHAR2	(150)		Descriptive flexfield segment
POL_ATTRIBUTE2	VARCHAR2	(150)		Descriptive flexfield segment
POL_ATTRIBUTE3	VARCHAR2	(150)		Descriptive flexfield segment
POL_ATTRIBUTE4	VARCHAR2	(150)		Descriptive flexfield segment
POL_ATTRIBUTE5	VARCHAR2	(150)		Descriptive flexfield segment
POL_ATTRIBUTE6	VARCHAR2	(150)		Descriptive flexfield segment
POL_ATTRIBUTE7	VARCHAR2	(150)		Descriptive flexfield segment
POL_ATTRIBUTE8	VARCHAR2	(150)		Descriptive flexfield segment
POL_ATTRIBUTE9	VARCHAR2	(150)		Descriptive flexfield segment
POL_ATTRIBUTE10	VARCHAR2	(150)		Descriptive flexfield segment
POL_ATTRIBUTE11	VARCHAR2	(150)		Descriptive flexfield segment
POL_ATTRIBUTE12	VARCHAR2	(150)		Descriptive flexfield segment
POL_ATTRIBUTE13	VARCHAR2	(150)		Descriptive flexfield segment
POL_ATTRIBUTE14	VARCHAR2	(150)		Descriptive flexfield segment
POL_ATTRIBUTE15	VARCHAR2	(150)		Descriptive flexfield segment
POL_GLOBAL_ATTRIBUTE_CATEGORY	VARCHAR2	(150)		Reserved for country-specific functionality
POL_GLOBAL_ATTRIBUTE1	VARCHAR2	(150)		Reserved for country-specific functionality
POL_GLOBAL_ATTRIBUTE2	VARCHAR2	(150)		Reserved for country-specific functionality
POL_GLOBAL_ATTRIBUTE3	VARCHAR2	(150)		Reserved for country-specific functionality
POL_GLOBAL_ATTRIBUTE4	VARCHAR2	(150)		Reserved for country-specific functionality
POL_GLOBAL_ATTRIBUTE5	VARCHAR2	(150)		Reserved for country-specific functionality
POL_GLOBAL_ATTRIBUTE6	VARCHAR2	(150)		Reserved for country-specific functionality
POL_GLOBAL_ATTRIBUTE7	VARCHAR2	(150)		Reserved for country-specific functionality
POL_GLOBAL_ATTRIBUTE8	VARCHAR2	(150)		Reserved for country-specific functionality
POL_GLOBAL_ATTRIBUTE9	VARCHAR2	(150)		Reserved for country-specific functionality
POL_GLOBAL_ATTRIBUTE10	VARCHAR2	(150)		Reserved for country-specific functionality
POL_GLOBAL_ATTRIBUTE11	VARCHAR2	(150)		Reserved for country-specific functionality
POL_GLOBAL_ATTRIBUTE12	VARCHAR2	(150)		Reserved for country-specific functionality
POL_GLOBAL_ATTRIBUTE13	VARCHAR2	(150)		Reserved for country-specific functionality
POL_GLOBAL_ATTRIBUTE14	VARCHAR2	(150)		Reserved for country-specific functionality
POL_GLOBAL_ATTRIBUTE15	VARCHAR2	(150)		Reserved for country-specific functionality
POL_GLOBAL_ATTRIBUTE16	VARCHAR2	(150)		Reserved for country-specific functionality
POL_GLOBAL_ATTRIBUTE17	VARCHAR2	(150)		Reserved for country-specific functionality
POL_GLOBAL_ATTRIBUTE18	VARCHAR2	(150)		Reserved for country-specific functionality
POL_GLOBAL_ATTRIBUTE19	VARCHAR2	(150)		Reserved for country-specific functionality
POL_GLOBAL_ATTRIBUTE20	VARCHAR2	(150)		Reserved for country-specific functionality
POL_LINE_REFERENCE_NUM	VARCHAR2	(25)		Audit Trail Reference (needed for 832 EDI transaction)
PO_DISTRIBUTION_ID	NUMBER		Yes	Document distribution unique identifier. Primary key for this table.
POD_ENCUMBERED_FLAG	VARCHAR2	(1)		Distribution encumbered flag
POD_ENCUMBERED_AMOUNT	NUMBER			Encumbered amount for distribution
POD_GL_ENCUMBERED_DATE	DATE			Date the distribution was encumbered
POD_GL_ENCUMBERED_PERIOD_NAME	VARCHAR2	(15)		Period in which the distribution was encumbered
POD_ATTRIBUTE_CATEGORY	VARCHAR2	(30)		Descriptive flexfield segment
POD_ATTRIBUTE1	VARCHAR2	(150)		Descriptive flexfield segment
POD_ATTRIBUTE2	VARCHAR2	(150)		Descriptive flexfield segment
POD_ATTRIBUTE3	VARCHAR2	(150)		Descriptive flexfield segment
POD_ATTRIBUTE4	VARCHAR2	(150)		Descriptive flexfield segment
POD_ATTRIBUTE5	VARCHAR2	(150)		Descriptive flexfield segment
POD_ATTRIBUTE6	VARCHAR2	(150)		Descriptive flexfield segment
POD_ATTRIBUTE7	VARCHAR2	(150)		Descriptive flexfield segment
POD_ATTRIBUTE8	VARCHAR2	(150)		Descriptive flexfield segment
POD_ATTRIBUTE9	VARCHAR2	(150)		Descriptive flexfield segment
POD_ATTRIBUTE10	VARCHAR2	(150)		Descriptive flexfield segment
POD_ATTRIBUTE11	VARCHAR2	(150)		Descriptive flexfield segment
POD_ATTRIBUTE12	VARCHAR2	(150)		Descriptive flexfield segment
POD_ATTRIBUTE13	VARCHAR2	(150)		Descriptive flexfield segment
POD_ATTRIBUTE14	VARCHAR2	(150)		Descriptive flexfield segment
POD_ATTRIBUTE15	VARCHAR2	(150)		Descriptive flexfield segment
POD_DISTRIBUTION_NUM	NUMBER		Yes	Distribution number
POD_ACCRUE_ON_RECEIPT_FLAG	VARCHAR2	(1)		Indicates whether items are accrued upon receipt
POD_CCID	NUMBER			Unique identifier for the General Ledger charge account. References GL_CODE_COMBINATIONS.CODE_COMBINATION_ID.
PO_VARIANCE_ACCOUNT	NUMBER			Unique identifier for the General Ledger variance account. References GL_CODE_COMBINATIONS.CODE_COMBINATION_ID.
RELATED_INV_DIST_DEST_TYPE	VARCHAR2	(25)		Final destination of the purchased items
POH_RATE	NUMBER			Currency conversion rate
POH_RATE_DATE	DATE			Currency conversion date
POH_RATE_TYPE	VARCHAR2	(30)		Currency conversion rate type (References GL_DAILY_CONVERSION_TYPES.conversion_type)

Query Text

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


SELECT PO_HEADER_ID
,      POH_TYPE_LOOKUP_CODE
,      PO_NUMBER
,      POH_SEGMENT2
,      POH_SEGMENT3
,      POH_SEGMENT4
,      POH_SEGMENT5
,      POH_STATUS_LOOKUP_CODE
,      POH_CURRENCY_CODE
,      POH_ATTRIBUTE_CATEGORY
,      POH_ATTRIBUTE1
,      POH_ATTRIBUTE2
,      POH_ATTRIBUTE3
,      POH_ATTRIBUTE4
,      POH_ATTRIBUTE5
,      POH_ATTRIBUTE6
,      POH_ATTRIBUTE7
,      POH_ATTRIBUTE8
,      POH_ATTRIBUTE9
,      POH_ATTRIBUTE10
,      POH_ATTRIBUTE11
,      POH_ATTRIBUTE12
,      POH_ATTRIBUTE13
,      POH_ATTRIBUTE14
,      POH_ATTRIBUTE15
,      POH_GLOBAL_ATTRIBUTE_CATEGORY
,      POH_GLOBAL_ATTRIBUTE1
,      POH_GLOBAL_ATTRIBUTE2
,      POH_GLOBAL_ATTRIBUTE3
,      POH_GLOBAL_ATTRIBUTE4
,      POH_GLOBAL_ATTRIBUTE5
,      POH_GLOBAL_ATTRIBUTE6
,      POH_GLOBAL_ATTRIBUTE7
,      POH_GLOBAL_ATTRIBUTE8
,      POH_GLOBAL_ATTRIBUTE9
,      POH_GLOBAL_ATTRIBUTE10
,      POH_GLOBAL_ATTRIBUTE11
,      POH_GLOBAL_ATTRIBUTE12
,      POH_GLOBAL_ATTRIBUTE13
,      POH_GLOBAL_ATTRIBUTE14
,      POH_GLOBAL_ATTRIBUTE15
,      POH_GLOBAL_ATTRIBUTE16
,      POH_GLOBAL_ATTRIBUTE17
,      POH_GLOBAL_ATTRIBUTE18
,      POH_GLOBAL_ATTRIBUTE19
,      POH_GLOBAL_ATTRIBUTE20
,      POH_REFERENCE_NUM
,      PO_LINE_ID
,      POL_LINE_TYPE_ID
,      POL_LINE_NUM
,      POL_ITEM_DESCRIPTION
,      POL_ATTRIBUTE_CATEGORY
,      POL_ATTRIBUTE1
,      POL_ATTRIBUTE2
,      POL_ATTRIBUTE3
,      POL_ATTRIBUTE4
,      POL_ATTRIBUTE5
,      POL_ATTRIBUTE6
,      POL_ATTRIBUTE7
,      POL_ATTRIBUTE8
,      POL_ATTRIBUTE9
,      POL_ATTRIBUTE10
,      POL_ATTRIBUTE11
,      POL_ATTRIBUTE12
,      POL_ATTRIBUTE13
,      POL_ATTRIBUTE14
,      POL_ATTRIBUTE15
,      POL_GLOBAL_ATTRIBUTE_CATEGORY
,      POL_GLOBAL_ATTRIBUTE1
,      POL_GLOBAL_ATTRIBUTE2
,      POL_GLOBAL_ATTRIBUTE3
,      POL_GLOBAL_ATTRIBUTE4
,      POL_GLOBAL_ATTRIBUTE5
,      POL_GLOBAL_ATTRIBUTE6
,      POL_GLOBAL_ATTRIBUTE7
,      POL_GLOBAL_ATTRIBUTE8
,      POL_GLOBAL_ATTRIBUTE9
,      POL_GLOBAL_ATTRIBUTE10
,      POL_GLOBAL_ATTRIBUTE11
,      POL_GLOBAL_ATTRIBUTE12
,      POL_GLOBAL_ATTRIBUTE13
,      POL_GLOBAL_ATTRIBUTE14
,      POL_GLOBAL_ATTRIBUTE15
,      POL_GLOBAL_ATTRIBUTE16
,      POL_GLOBAL_ATTRIBUTE17
,      POL_GLOBAL_ATTRIBUTE18
,      POL_GLOBAL_ATTRIBUTE19
,      POL_GLOBAL_ATTRIBUTE20
,      POL_LINE_REFERENCE_NUM
,      PO_DISTRIBUTION_ID
,      POD_ENCUMBERED_FLAG
,      POD_ENCUMBERED_AMOUNT
,      POD_GL_ENCUMBERED_DATE
,      POD_GL_ENCUMBERED_PERIOD_NAME
,      POD_ATTRIBUTE_CATEGORY
,      POD_ATTRIBUTE1
,      POD_ATTRIBUTE2
,      POD_ATTRIBUTE3
,      POD_ATTRIBUTE4
,      POD_ATTRIBUTE5
,      POD_ATTRIBUTE6
,      POD_ATTRIBUTE7
,      POD_ATTRIBUTE8
,      POD_ATTRIBUTE9
,      POD_ATTRIBUTE10
,      POD_ATTRIBUTE11
,      POD_ATTRIBUTE12
,      POD_ATTRIBUTE13
,      POD_ATTRIBUTE14
,      POD_ATTRIBUTE15
,      POD_DISTRIBUTION_NUM
,      POD_ACCRUE_ON_RECEIPT_FLAG
,      POD_CCID
,      PO_VARIANCE_ACCOUNT
,      RELATED_INV_DIST_DEST_TYPE
,      POH_RATE
,      POH_RATE_DATE
,      POH_RATE_TYPE
FROM APPS.AP_PO_DETAILS_V;

Dependencies

[top of page]

APPS.AP_PO_DETAILS_V references the following:

APPS: PO_DISTRIBUTIONS_ALL; PO_HEADERS_ALL; PO_LINES_ALL

APPS.AP_PO_DETAILS_V is not referenced by any database object