AP_HOLDS_ALL
AP_HOLDS_ALL contains information about holds that you or your Oracle Payables application place on an invoice. For non-matching holds, there is one row for each hold placed on an invoice. For matching holds, there is one row for each hold placed on an invoice-shipment match. An invoice may have one or more corresponding rows in this table. Your Oracle Payables application does not pay invoices that have one or more unreleased holds recorded in this table. This table holds information referenced by the Invoice Holds page. In the strictest sense, AP_HOLDS_ALL has no primary key. It is possible for your Oracle Payables application to place a certain type of hold on an invoice, then release it, then place another hold of the same type (if data changes before each submission of Payables Invoice Validation), which would result in a duplicate primary key. But for practical purposes, the primary key is a concatenation of INVOICE_ID, LINE_LOCATION_ID, and HOLD_LOOKUP_CODE.
Details
-
Schema: FUSION
-
Object owner: AP
-
Object type: TABLE
-
Tablespace: APPS_TS_TX_DATA
Primary Key
| Name | Columns |
|---|---|
|
AP_HOLDS_ALL_PK |
HOLD_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments | Flexfield-mapping |
|---|---|---|---|---|---|---|
| INVOICE_ID | NUMBER | 18 | Yes | Unique invoice identifier that identifies the invoice against which a hold is placed. | ||
| LINE_LOCATION_ID | NUMBER | 18 | Purchase order line location identifier | |||
| HOLD_LOOKUP_CODE | VARCHAR2 | 25 | Yes | Name of the hold that is applied on an invoice line. | ||
| LAST_UPDATE_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the last update of the row. | |||
| LAST_UPDATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who last updated the row. | ||
| HELD_BY | VARCHAR2 | 64 | Yes | User that placed hold on invoice | ||
| HOLD_DATE | TIMESTAMP | Yes | Date user placed hold on invoice | |||
| HOLD_REASON | VARCHAR2 | 240 | Reason for hold being placed on invoice | |||
| RELEASE_LOOKUP_CODE | VARCHAR2 | 25 | Release name that released the hold on the invoice. | |||
| RELEASE_REASON | VARCHAR2 | 240 | Reason for release being placed on invoice | |||
| LAST_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to the user who last updated the row. | |||
| CREATION_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the creation of the row. | |||
| CREATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who created the row. | ||
| ATTRIBUTE_CATEGORY | VARCHAR2 | 150 | Descriptive Flexfield: structure definition of the user descriptive flexfield. | Invoice Holds (AP_HOLDS) | ||
| ATTRIBUTE1 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Invoice Holds (AP_HOLDS) | ||
| ATTRIBUTE2 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Invoice Holds (AP_HOLDS) | ||
| ATTRIBUTE3 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Invoice Holds (AP_HOLDS) | ||
| ATTRIBUTE4 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Invoice Holds (AP_HOLDS) | ||
| ATTRIBUTE5 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Invoice Holds (AP_HOLDS) | ||
| ATTRIBUTE6 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Invoice Holds (AP_HOLDS) | ||
| ATTRIBUTE7 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Invoice Holds (AP_HOLDS) | ||
| ATTRIBUTE8 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Invoice Holds (AP_HOLDS) | ||
| ATTRIBUTE9 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Invoice Holds (AP_HOLDS) | ||
| ATTRIBUTE10 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Invoice Holds (AP_HOLDS) | ||
| ATTRIBUTE11 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Invoice Holds (AP_HOLDS) | ||
| ATTRIBUTE12 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Invoice Holds (AP_HOLDS) | ||
| ATTRIBUTE13 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Invoice Holds (AP_HOLDS) | ||
| ATTRIBUTE14 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Invoice Holds (AP_HOLDS) | ||
| ATTRIBUTE15 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Invoice Holds (AP_HOLDS) | ||
| ORG_ID | NUMBER | 18 | Yes | Indicates the identifier of the business unit associated to the row. | ||
| RESPONSIBILITY_ID | NUMBER | 18 | Responsibility identifier associated with Insufficient Funds hold | |||
| RCV_TRANSACTION_ID | NUMBER | Receipt identifier, RCV_TRANSACTIONS.TRANSACTION_ID, of receipt that this hold is associated with. | ||||
| HOLD_DETAILS | VARCHAR2 | 2000 | Details of the hold that is placed on the invoice line. | |||
| LINE_NUMBER | NUMBER | Invoice line number of the applied hold | ||||
| HOLD_ID | NUMBER | 18 | Yes | An identifier that identifies the hold placed on an invoice. | ||
| WF_STATUS | VARCHAR2 | 30 | Holds resolution workflow status | |||
| STATUS_FLAG | VARCHAR2 | 25 | An identifier that identifies the hold record created in the Holds table. | |||
| OBJECT_VERSION_NUMBER | NUMBER | 9 | Yes | Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried. | ||
| CONSUMPTION_ADVICE_LINE_ID | NUMBER | 18 | Consumption advice identifier of consumption advice line that the hold is assoicated with. | |||
| VALIDATION_REQUEST_ID | NUMBER | 18 | Temporarily stores the Enterprise Scheduler Service request identifier of Payables Invoice Validation batch program. | |||
| GROUP_ID | NUMBER | 18 | The identifier for the hold group that generates hold notifications with multiple hold details. |
Foreign Keys
| Table | Foreign Table | Foreign Key Column |
|---|---|---|
| AP_HOLDS_ALL | ap_invoices_all | INVOICE_ID |
| AP_HOLDS_ALL | ap_hold_codes | HOLD_LOOKUP_CODE |
| AP_HOLDS_ALL | ap_hold_codes | RELEASE_LOOKUP_CODE |
| AP_HOLDS_ALL | po_line_locations_all | LINE_LOCATION_ID |
| AP_HOLDS_ALL | rcv_transactions | RCV_TRANSACTION_ID |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| AP_HOLDS_ALL_F1 | Non Unique | Default | NVL("RELEASE_LOOKUP_CODE", 'null'), ORG_ID |
| AP_HOLDS_ALL_U1 | Unique | Default | HOLD_ID |
| AP_HOLDS_N1 | Non Unique | Default | INVOICE_ID |
| AP_HOLDS_N2 | Non Unique | Default | LINE_LOCATION_ID |