[Home] [Help]
[Dependency Information]
| Object Name: | PO_PRICE_ADJS_VAL_TYPE |
|---|---|
| Object Type: | TYPE |
| Owner: | APPS |
| Subobject Name: | |
| Status: | VALID |
| Type Code: | OBJECT |
|---|---|
| Predefined: | NO |
| Incomplete: | NO |
| Name | Datatype | Length | Prcn |
|---|---|---|---|
| DRAFT_ID |
PO_TBL_NUMBER
|
|
|
| CHANGE_ACCEPTED_FLAG |
PO_TBL_VARCHAR1
|
|
|
| DELETE_FLAG |
PO_TBL_VARCHAR1
|
|
|
| PRICE_ADJUSTMENT_ID |
PO_TBL_NUMBER
|
|
|
| CREATION_DATE |
PO_TBL_DATE
|
|
|
| CREATED_BY |
PO_TBL_NUMBER
|
|
|
| LAST_UPDATE_DATE |
PO_TBL_DATE
|
|
|
| LAST_UPDATED_BY |
PO_TBL_NUMBER
|
|
|
| LAST_UPDATE_LOGIN |
PO_TBL_NUMBER
|
|
|
| PROGRAM_APPLICATION_ID |
PO_TBL_NUMBER
|
|
|
| PROGRAM_ID |
PO_TBL_NUMBER
|
|
|
| PROGRAM_UPDATE_DATE |
PO_TBL_DATE
|
|
|
| REQUEST_ID |
PO_TBL_NUMBER
|
|
|
| PO_HEADER_ID |
PO_TBL_NUMBER
|
|
|
| AUTOMATIC_FLAG |
PO_TBL_VARCHAR1
|
|
|
| PO_LINE_ID |
PO_TBL_NUMBER
|
|
|
| ADJ_LINE_NUM |
PO_TBL_NUMBER
|
|
|
| CONTEXT |
PO_TBL_VARCHAR30
|
|
|
| ATTRIBUTE1 |
PO_TBL_VARCHAR2000
|
|
|
| ATTRIBUTE2 |
PO_TBL_VARCHAR2000
|
|
|
| ATTRIBUTE3 |
PO_TBL_VARCHAR2000
|
|
|
| ATTRIBUTE4 |
PO_TBL_VARCHAR2000
|
|
|
| ATTRIBUTE5 |
PO_TBL_VARCHAR2000
|
|
|
| ATTRIBUTE6 |
PO_TBL_VARCHAR2000
|
|
|
| ATTRIBUTE7 |
PO_TBL_VARCHAR2000
|
|
|
| ATTRIBUTE8 |
PO_TBL_VARCHAR2000
|
|
|
| ATTRIBUTE9 |
PO_TBL_VARCHAR2000
|
|
|
| ATTRIBUTE10 |
PO_TBL_VARCHAR2000
|
|
|
| ATTRIBUTE11 |
PO_TBL_VARCHAR2000
|
|
|
| ATTRIBUTE12 |
PO_TBL_VARCHAR2000
|
|
|
| ATTRIBUTE13 |
PO_TBL_VARCHAR2000
|
|
|
| ATTRIBUTE14 |
PO_TBL_VARCHAR2000
|
|
|
| ATTRIBUTE15 |
PO_TBL_VARCHAR2000
|
|
|
| ORIG_SYS_DISCOUNT_REF |
PO_TBL_VARCHAR2000
|
|
|
| CHANGE_SEQUENCE |
PO_TBL_VARCHAR2000
|
|
|
| LIST_HEADER_ID |
PO_TBL_NUMBER
|
|
|
| LIST_TYPE_CODE |
PO_TBL_VARCHAR30
|
|
|
| LIST_LINE_ID |
PO_TBL_NUMBER
|
|
|
| LIST_LINE_TYPE_CODE |
PO_TBL_VARCHAR30
|
|
|
| MODIFIED_FROM |
PO_TBL_VARCHAR2000
|
|
|
| MODIFIED_TO |
PO_TBL_VARCHAR2000
|
|
|
| UPDATE_ALLOWED |
PO_TBL_VARCHAR1
|
|
|
| CHANGE_REASON_CODE |
PO_TBL_VARCHAR30
|
|
|
| CHANGE_REASON_TEXT |
PO_TBL_VARCHAR2000
|
|
|
| UPDATED_FLAG |
PO_TBL_VARCHAR1
|
|
|
| APPLIED_FLAG |
PO_TBL_VARCHAR1
|
|
|
| OPERAND |
PO_TBL_NUMBER
|
|
|
| ARITHMETIC_OPERATOR |
PO_TBL_VARCHAR30
|
|
|
| COST_ID |
PO_TBL_NUMBER
|
|
|
| TAX_CODE |
PO_TBL_VARCHAR2000
|
|
|
| TAX_EXEMPT_FLAG |
PO_TBL_VARCHAR1
|
|
|
| TAX_EXEMPT_NUMBER |
PO_TBL_VARCHAR2000
|
|
|
| TAX_EXEMPT_REASON_CODE |
PO_TBL_VARCHAR30
|
|
|
| PARENT_ADJUSTMENT_ID |
PO_TBL_NUMBER
|
|
|
| INVOICED_FLAG |
PO_TBL_VARCHAR1
|
|
|
| ESTIMATED_FLAG |
PO_TBL_VARCHAR1
|
|
|
| INC_IN_SALES_PERFORMANCE |
PO_TBL_VARCHAR1
|
|
|
| ADJUSTED_AMOUNT |
PO_TBL_NUMBER
|
|
|
| PRICING_PHASE_ID |
PO_TBL_NUMBER
|
|
|
| CHARGE_TYPE_CODE |
PO_TBL_VARCHAR30
|
|
|
| CHARGE_SUBTYPE_CODE |
PO_TBL_VARCHAR30
|
|
|
| RANGE_BREAK_QUANTITY |
PO_TBL_NUMBER
|
|
|
| ACCRUAL_CONVERSION_RATE |
PO_TBL_NUMBER
|
|
|
| PRICING_GROUP_SEQUENCE |
PO_TBL_NUMBER
|
|
|
| ACCRUAL_FLAG |
PO_TBL_VARCHAR1
|
|
|
| LIST_LINE_NO |
PO_TBL_VARCHAR2000
|
|
|
| SOURCE_SYSTEM_CODE |
PO_TBL_VARCHAR30
|
|
|
| BENEFIT_QTY |
PO_TBL_NUMBER
|
|
|
| BENEFIT_UOM_CODE |
PO_TBL_VARCHAR30
|
|
|
| PRINT_ON_INVOICE_FLAG |
PO_TBL_VARCHAR1
|
|
|
| EXPIRATION_DATE |
PO_TBL_DATE
|
|
|
| REBATE_TRANSACTION_TYPE_CODE |
PO_TBL_VARCHAR30
|
|
|
| REBATE_TRANSACTION_REFERENCE |
PO_TBL_VARCHAR2000
|
|
|
| REBATE_PAYMENT_SYSTEM_CODE |
PO_TBL_VARCHAR30
|
|
|
| REDEEMED_DATE |
PO_TBL_DATE
|
|
|
| REDEEMED_FLAG |
PO_TBL_VARCHAR1
|
|
|
| MODIFIER_LEVEL_CODE |
PO_TBL_VARCHAR30
|
|
|
| PRICE_BREAK_TYPE_CODE |
PO_TBL_VARCHAR30
|
|
|
| SUBSTITUTION_ATTRIBUTE |
PO_TBL_VARCHAR30
|
|
|
| PRORATION_TYPE_CODE |
PO_TBL_VARCHAR30
|
|
|
| INCLUDE_ON_RETURNS_FLAG |
PO_TBL_VARCHAR1
|
|
|
| CREDIT_OR_CHARGE_FLAG |
PO_TBL_VARCHAR1
|
|
|
| AC_CONTEXT |
PO_TBL_VARCHAR2000
|
|
|
| AC_ATTRIBUTE1 |
PO_TBL_VARCHAR2000
|
|
|
| AC_ATTRIBUTE2 |
PO_TBL_VARCHAR2000
|
|
|
| AC_ATTRIBUTE3 |
PO_TBL_VARCHAR2000
|
|
|
| AC_ATTRIBUTE4 |
PO_TBL_VARCHAR2000
|
|
|
| AC_ATTRIBUTE5 |
PO_TBL_VARCHAR2000
|
|
|
| AC_ATTRIBUTE6 |
PO_TBL_VARCHAR2000
|
|
|
| AC_ATTRIBUTE7 |
PO_TBL_VARCHAR2000
|
|
|
| AC_ATTRIBUTE8 |
PO_TBL_VARCHAR2000
|
|
|
| AC_ATTRIBUTE9 |
PO_TBL_VARCHAR2000
|
|
|
| AC_ATTRIBUTE10 |
PO_TBL_VARCHAR2000
|
|
|
| AC_ATTRIBUTE11 |
PO_TBL_VARCHAR2000
|
|
|
| AC_ATTRIBUTE12 |
PO_TBL_VARCHAR2000
|
|
|
| AC_ATTRIBUTE13 |
PO_TBL_VARCHAR2000
|
|
|
| AC_ATTRIBUTE14 |
PO_TBL_VARCHAR2000
|
|
|
| AC_ATTRIBUTE15 |
PO_TBL_VARCHAR2000
|
|
|
| OPERAND_PER_PQTY |
PO_TBL_NUMBER
|
|
|
| ADJUSTED_AMOUNT_PER_PQTY |
PO_TBL_NUMBER
|
|
|
| INTERCO_INVOICED_FLAG |
PO_TBL_VARCHAR1
|
|
|
| INVOICED_AMOUNT |
PO_TBL_NUMBER
|
|
|
| RETROBILL_REQUEST_ID |
PO_TBL_NUMBER
|
|
|
| TAX_RATE_ID |
PO_TBL_NUMBER
|
|
| Name | Parameters | Result |
|---|---|---|
| PO_PRICE_ADJS_VAL_TYPE |
SELF(PO_PRICE_ADJS_VAL_TYPE) |
PO_PRICE_ADJS_VAL_TYPE |
APPS
PO_TBL_DATE
PO_TBL_NUMBER
PO_TBL_VARCHAR1
PO_TBL_VARCHAR2000
PO_TBL_VARCHAR30
APPS
PO_MOD_SYNC_PROCESS_PVT
- show dependent code
PO_PRICE_ADJS_VAL_TYPE
PO_VALIDATIONS
- show dependent code
PO_VALIDATIONS
- show dependent code
|
|
|
|