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


VIEW: APPS.OE_AK_HEADER_PRCADJS_V

Object Details
Object Name: OE_AK_HEADER_PRCADJS_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewONT.OE_AK_HEADER_PRCADJS_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
ATTRIBUTE1 VARCHAR2 (240)
ATTRIBUTE10 VARCHAR2 (240)
ATTRIBUTE11 VARCHAR2 (240)
ATTRIBUTE12 VARCHAR2 (240)
ATTRIBUTE13 VARCHAR2 (240)
ATTRIBUTE14 VARCHAR2 (240)
ATTRIBUTE15 VARCHAR2 (240)
ATTRIBUTE2 VARCHAR2 (240)
ATTRIBUTE3 VARCHAR2 (240)
ATTRIBUTE4 VARCHAR2 (240)
ATTRIBUTE5 VARCHAR2 (240)
ATTRIBUTE6 VARCHAR2 (240)
ATTRIBUTE7 VARCHAR2 (240)
ATTRIBUTE8 VARCHAR2 (240)
ATTRIBUTE9 VARCHAR2 (240)
AUTOMATIC_FLAG VARCHAR2 (1) Yes
CONTEXT VARCHAR2 (30)
CREATED_BY NUMBER
Yes
CREATION_DATE DATE
Yes
DISCOUNT_ID NUMBER

DISCOUNT_LINE_ID NUMBER

HEADER_ID NUMBER
Yes
LAST_UPDATED_BY NUMBER
Yes
LAST_UPDATE_DATE DATE
Yes
LAST_UPDATE_LOGIN NUMBER

LINE_ID NUMBER

PERCENT NUMBER

PRICE_ADJUSTMENT_ID NUMBER
Yes
PROGRAM_APPLICATION_ID NUMBER

PROGRAM_ID NUMBER

PROGRAM_UPDATE_DATE DATE

REQUEST_ID NUMBER

RETURN_STATUS VARCHAR2 (1)
DB_FLAG VARCHAR2 (1)
OPERATION VARCHAR2 (30)
LIST_HEADER_ID NUMBER

LIST_LINE_ID NUMBER

LIST_LINE_TYPE_CODE VARCHAR2 (30)
MODIFIER_MECHANISM_TYPE_CODE VARCHAR2 (30)
MODIFIED_FROM VARCHAR2 (240)
MODIFIED_TO VARCHAR2 (240)
UPDATED_FLAG VARCHAR2 (1)
UPDATE_ALLOWED VARCHAR2 (1)
APPLIED_FLAG VARCHAR2 (1)
CHANGE_REASON_CODE VARCHAR2 (30)
CHANGE_REASON_TEXT VARCHAR2 (2000)
OPERAND NUMBER

ARITHMETIC_OPERATOR VARCHAR2 (30)
COST_ID NUMBER

TAX_CODE VARCHAR2 (50)
TAX_EXEMPT_FLAG VARCHAR2 (1)
TAX_EXEMPT_NUMBER VARCHAR2 (80)
TAX_EXEMPT_REASON_CODE VARCHAR2 (30)
PARENT_ADJUSTMENT_ID NUMBER

INVOICED_FLAG VARCHAR2 (1)
ESTIMATED_FLAG VARCHAR2 (1)
INC_IN_SALES_PERFORMANCE VARCHAR2 (1)
SPLIT_ACTION_CODE VARCHAR2 (30)
ADJUSTED_AMOUNT NUMBER

PRICING_PHASE_ID NUMBER

CHARGE_TYPE_CODE VARCHAR2 (30)
CHARGE_SUBTYPE_CODE VARCHAR2 (30)
LIST_LINE_NO VARCHAR2 (240)
SOURCE_SYSTEM_CODE VARCHAR2 (30)
BENEFIT_QTY NUMBER

BENEFIT_UOM_CODE VARCHAR2 (3)
PRINT_ON_INVOICE_FLAG VARCHAR2 (1)
EXPIRATION_DATE DATE

REBATE_TRANSACTION_TYPE_CODE VARCHAR2 (30)
REBATE_TRANSACTION_REFERENCE VARCHAR2 (80)
REBATE_PAYMENT_SYSTEM_CODE VARCHAR2 (30)
REDEEMED_DATE DATE

REDEEMED_FLAG VARCHAR2 (1)
ACCRUAL_FLAG VARCHAR2 (1)
RANGE_BREAK_QUANTITY NUMBER

ACCRUAL_CONVERSION_RATE NUMBER

PRICING_GROUP_SEQUENCE NUMBER

MODIFIER_LEVEL_CODE VARCHAR2 (30)
PRICE_BREAK_TYPE_CODE VARCHAR2 (30)
SUBSTITUTION_ATTRIBUTE VARCHAR2 (30)
PRORATION_TYPE_CODE VARCHAR2 (30)
CREDIT_OR_CHARGE_FLAG VARCHAR2 (1)
INCLUDE_ON_RETURNS_FLAG VARCHAR2 (1)
AC_CONTEXT VARCHAR2 (150)
AC_ATTRIBUTE1 VARCHAR2 (240)
AC_ATTRIBUTE2 VARCHAR2 (240)
AC_ATTRIBUTE3 VARCHAR2 (240)
AC_ATTRIBUTE4 VARCHAR2 (240)
AC_ATTRIBUTE5 VARCHAR2 (240)
AC_ATTRIBUTE6 VARCHAR2 (240)
AC_ATTRIBUTE7 VARCHAR2 (240)
AC_ATTRIBUTE8 VARCHAR2 (240)
AC_ATTRIBUTE9 VARCHAR2 (240)
AC_ATTRIBUTE10 VARCHAR2 (240)
AC_ATTRIBUTE11 VARCHAR2 (240)
AC_ATTRIBUTE12 VARCHAR2 (240)
AC_ATTRIBUTE13 VARCHAR2 (240)
AC_ATTRIBUTE14 VARCHAR2 (240)
AC_ATTRIBUTE15 VARCHAR2 (240)
OPERAND_PER_PQTY NUMBER

ADJUSTED_AMOUNT_PER_PQTY NUMBER

INVOICED_AMOUNT NUMBER

ORIG_SYS_DISCOUNT_REF VARCHAR2 (50)
Query Text

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


SELECT ATTRIBUTE1
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      AUTOMATIC_FLAG
,      CONTEXT
,      CREATED_BY
,      CREATION_DATE
,      DISCOUNT_ID
,      DISCOUNT_LINE_ID
,      HEADER_ID
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      LINE_ID
,      PERCENT
,      PRICE_ADJUSTMENT_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      REQUEST_ID
,      RETURN_STATUS
,      DB_FLAG
,      OPERATION
,      LIST_HEADER_ID
,      LIST_LINE_ID
,      LIST_LINE_TYPE_CODE
,      MODIFIER_MECHANISM_TYPE_CODE
,      MODIFIED_FROM
,      MODIFIED_TO
,      UPDATED_FLAG
,      UPDATE_ALLOWED
,      APPLIED_FLAG
,      CHANGE_REASON_CODE
,      CHANGE_REASON_TEXT
,      OPERAND
,      ARITHMETIC_OPERATOR
,      COST_ID
,      TAX_CODE
,      TAX_EXEMPT_FLAG
,      TAX_EXEMPT_NUMBER
,      TAX_EXEMPT_REASON_CODE
,      PARENT_ADJUSTMENT_ID
,      INVOICED_FLAG
,      ESTIMATED_FLAG
,      INC_IN_SALES_PERFORMANCE
,      SPLIT_ACTION_CODE
,      ADJUSTED_AMOUNT
,      PRICING_PHASE_ID
,      CHARGE_TYPE_CODE
,      CHARGE_SUBTYPE_CODE
,      LIST_LINE_NO
,      SOURCE_SYSTEM_CODE
,      BENEFIT_QTY
,      BENEFIT_UOM_CODE
,      PRINT_ON_INVOICE_FLAG
,      EXPIRATION_DATE
,      REBATE_TRANSACTION_TYPE_CODE
,      REBATE_TRANSACTION_REFERENCE
,      REBATE_PAYMENT_SYSTEM_CODE
,      REDEEMED_DATE
,      REDEEMED_FLAG
,      ACCRUAL_FLAG
,      RANGE_BREAK_QUANTITY
,      ACCRUAL_CONVERSION_RATE
,      PRICING_GROUP_SEQUENCE
,      MODIFIER_LEVEL_CODE
,      PRICE_BREAK_TYPE_CODE
,      SUBSTITUTION_ATTRIBUTE
,      PRORATION_TYPE_CODE
,      CREDIT_OR_CHARGE_FLAG
,      INCLUDE_ON_RETURNS_FLAG
,      AC_CONTEXT
,      AC_ATTRIBUTE1
,      AC_ATTRIBUTE2
,      AC_ATTRIBUTE3
,      AC_ATTRIBUTE4
,      AC_ATTRIBUTE5
,      AC_ATTRIBUTE6
,      AC_ATTRIBUTE7
,      AC_ATTRIBUTE8
,      AC_ATTRIBUTE9
,      AC_ATTRIBUTE10
,      AC_ATTRIBUTE11
,      AC_ATTRIBUTE12
,      AC_ATTRIBUTE13
,      AC_ATTRIBUTE14
,      AC_ATTRIBUTE15
,      OPERAND_PER_PQTY
,      ADJUSTED_AMOUNT_PER_PQTY
,      INVOICED_AMOUNT
,      ORIG_SYS_DISCOUNT_REF
FROM APPS.OE_AK_HEADER_PRCADJS_V;

Dependencies

[top of page]

APPS.OE_AK_HEADER_PRCADJS_V references the following:

SchemaAPPS
ViewOE_PRICE_ADJUSTMENTS_V
APPS.OE_AK_HEADER_PRCADJS_V is referenced by following:

SchemaAPPS
Package BodyOE_1PC6_HDRADJ_ADJINV - show dependent code
Package BodyOE_1PC6_HDRADJ_DISSUR - show dependent code
Package BodyOE_1PC6_HDRADJ_FRTCHG - show dependent code
Package BodyOE_6PC1_ORDER_AHLORD - show dependent code
Package BodyOE_6PC1_ORDER_BOOKED - show dependent code
Package BodyOE_6PC1_ORDER_CANORD - show dependent code
Package BodyOE_6PC1_ORDER_CLOSED - show dependent code
Package BodyOE_6PC1_ORDER_CUSTACC - show dependent code
Package BodyOE_6PC1_ORDER_CUSTREJ - show dependent code
Package BodyOE_6PC1_ORDER_CUSTSIG - show dependent code
Package BodyOE_6PC1_ORDER_DEALAPP - show dependent code
Package BodyOE_6PC1_ORDER_DEALSUB - show dependent code
Package BodyOE_6PC1_ORDER_DRAFSUB - show dependent code
Package BodyOE_6PC1_ORDER_DRAFT - show dependent code
Package BodyOE_6PC1_ORDER_ENTER - show dependent code
Package BodyOE_6PC1_ORDER_HDRINVC - show dependent code
Package BodyOE_6PC1_ORDER_INTAPPR - show dependent code
Package BodyOE_6PC1_ORDER_INTORD - show dependent code
Package BodyOE_6PC1_ORDER_INTREJ - show dependent code
Package BodyOE_6PC1_ORDER_LOST - show dependent code
Package BodyOE_6PC1_ORDER_NEGCOMP - show dependent code
Package BodyOE_6PC1_ORDER_OFFEXP - show dependent code
Package BodyOE_6PC1_ORDER_PENAPPR - show dependent code
Package BodyOE_6PC1_ORDER_PENCUSA - show dependent code
Package BodyOE_6PC1_ORDER_REGORD - show dependent code
Package BodyOE_6PC1_ORDER_RETAPVD - show dependent code
Package BodyOE_6PC1_ORDER_RETORD - show dependent code
Package BodyOE_6PC1_ORDER_RETREJ - show dependent code
Package BodyOE_6PC1_ORDER_RETREJA - show dependent code
Package BodyOE_6PC1_ORDER_RETREJD - show dependent code
Package BodyOE_6PC6_HDRADJS_ADJINV - show dependent code
Package BodyOE_6PC6_HDRADJS_DISSUR - show dependent code
Package BodyOE_6PC6_HDRADJS_FRTCHG - show dependent code
Package BodyOE_6PC6_HDRADJ_ADJINV - show dependent code
Package BodyOE_6PC6_HDRADJ_DISSUR - show dependent code
Package BodyOE_6PC6_HDRADJ_FRTCHG - show dependent code
Package BodyOE_CHECKLINE_PUB - show dependent code
Package BodyOE_HEADER_ADJ_CL_DEP_ATTR - show dependent code
PL/SQL PackageOE_HEADER_ADJ_CL_DEP_ATTR - show dependent code
PL/SQL PackageOE_HEADER_ADJ_PCFWK - show dependent code
Package BodyOE_HEADER_ADJ_PCFWK - show dependent code
PL/SQL PackageOE_HEADER_ADJ_SECURITY - show dependent code
Package BodyOE_HEADER_ADJ_SECURITY - show dependent code
Package BodyOE_HEADER_ADJ_UTIL - show dependent code
PL/SQL PackageOE_HEADER_ADJ_UTIL - show dependent code
Package BodyOE_INVOICE_PUB - show dependent code
PL/SQL PackageONT_HEADER_ADJ_DEF_HDLR - show dependent code