[Home] [Help] [Dependency Information]
Object Name: | AP_HOLD_CODES |
---|---|
Object Type: | TABLE |
Owner: | AP |
FND Design Data: | SQLAP.AP_HOLD_CODES |
Subobject Name: | |
Status: | VALID |
AP_HOLD_CODES contains information about hold codes and release codes that you or your Oracle Payables application can place on an invoice. There is one row for each hold or release code. When you enter or validate an invoice, you can select a hold code that you defined in this table. Your Oracle Payables application also uses these hold codes when it places matching and tax variance holds during Invoice Validation.
.
Your Oracle Payables application stores translations of HOLD_LOOKUP_CODES in the AP_LOOKUP_CODES table.
.
This table corresponds to the Invoice Hold and Release Names window.
Tablespace: | APPS_TS_SEED |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
AP_HOLD_CODES_U1 | NORMAL | UNIQUE | APPS_TS_SEED | HOLD_LOOKUP_CODE |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
HOLD_LOOKUP_CODE | VARCHAR2 | (25) | Yes | Name of hold code |
HOLD_TYPE | VARCHAR2 | (25) | Yes | Type of hold |
DESCRIPTION | VARCHAR2 | (80) | Description | |
LAST_UPDATE_DATE | DATE | Yes | Standard Who column - date when a user last updated this row. | |
LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). |
USER_RELEASEABLE_FLAG | VARCHAR2 | (1) | Yes | Flag that indicates if hold can be released by user (Y or N) |
USER_UPDATEABLE_FLAG | VARCHAR2 | (1) | Yes | Flag that indicates if hold can be updated by user (Y or N) |
INACTIVE_DATE | DATE | Inactive date | ||
POSTABLE_FLAG | VARCHAR2 | (1) | Yes | Flag that indicates whether this hold should prevent the invoice from being accounted |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID). | |
CREATION_DATE | DATE | Standard who column - date when this row was created. | ||
CREATED_BY | NUMBER | (15) | Standard who column - user who created this row (foreign key to FND_USER.USER_ID). | |
EXTERNAL_DESCRIPTION | VARCHAR2 | (80) | Hold description for external users. | |
HOLD_INSTRUCTION | VARCHAR2 | (2000) | Instruction to resolve the hold | |
WAIT_BEFORE_NOTIFY_DAYS | NUMBER | Specify the number of days to wait before sending the notification. | ||
REMINDER_DAYS | NUMBER | Specify the number of days to wait before sending the reminder notification. | ||
INITIATE_WORKFLOW_FLAG | VARCHAR2 | (1) | Enable this to initiate the Hold Negotiation Workflow for the hold. |
Cut, paste (and edit) the following text to query this object:
SELECT HOLD_LOOKUP_CODE
, HOLD_TYPE
, DESCRIPTION
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, USER_RELEASEABLE_FLAG
, USER_UPDATEABLE_FLAG
, INACTIVE_DATE
, POSTABLE_FLAG
, LAST_UPDATE_LOGIN
, CREATION_DATE
, CREATED_BY
, EXTERNAL_DESCRIPTION
, HOLD_INSTRUCTION
, WAIT_BEFORE_NOTIFY_DAYS
, REMINDER_DAYS
, INITIATE_WORKFLOW_FLAG
FROM AP.AP_HOLD_CODES;
AP.AP_HOLD_CODES does not reference any database object
AP.AP_HOLD_CODES is referenced by following:
|
|
|