[Home] [Help]
[Dependency Information]
| Object Name: | OE_ORDER_PUB_LINE_ADJ_REC_TYP |
|---|---|
| Object Type: | TYPE |
| Owner: | APPS |
| Subobject Name: | |
| Status: | VALID |
| Type Code: | OBJECT |
|---|---|
| Predefined: | NO |
| Incomplete: | NO |
| Name | Datatype | Length | Prcn |
|---|---|---|---|
| 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) | |
| CONTEXT | VARCHAR2 | (30) | |
| CREATED_BY | NUMBER |
|
|
| CREATION_DATE | DATE |
|
|
| DISCOUNT_ID | NUMBER |
|
|
| DISCOUNT_LINE_ID | NUMBER |
|
|
| HEADER_ID | NUMBER |
|
|
| LAST_UPDATED_BY | NUMBER |
|
|
| LAST_UPDATE_DATE | DATE |
|
|
| LAST_UPDATE_LOGIN | NUMBER |
|
|
| LINE_ID | NUMBER |
|
|
| PERCENT | NUMBER |
|
|
| PRICE_ADJUSTMENT_ID | NUMBER |
|
|
| 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) | |
| LINE_INDEX | NUMBER |
|
|
| ORIG_SYS_DISCOUNT_REF | VARCHAR2 | (50) | |
| CHANGE_REQUEST_CODE | VARCHAR2 | (30) | |
| STATUS_FLAG | VARCHAR2 | (1) | |
| 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 |
|
|
| OPERAND_PER_PQTY | 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 |
|
|
| ADJUSTED_AMOUNT_PER_PQTY | 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_ATTRIBUTE1 | 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) | |
| 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_CONTEXT | VARCHAR2 | (150) | |
| LOCK_CONTROL | NUMBER |
|
|
| GROUP_VALUE | NUMBER |
|
|
| INVOICED_AMOUNT | NUMBER |
|
|
| RETROBILL_REQUEST_ID | NUMBER |
|
SYS
STANDARD
- show dependent code
APPS
OE_INBOUND_INT
- show dependent code
OE_INBOUND_INT
- show dependent code
OE_ORDER_PUB_LINE_ADJ_TBL_TYP
XX_BPEL_CALLPROCESSORDEREBS11I
- show dependent code
XX_BPEL_CALLPROCESSORDEREBS11I
- show dependent code
|
|
|
|