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

TABLE: ICX.ICX_POR_BUYER_APPROVAL_JOBS

Object Details
Object Name: ICX_POR_BUYER_APPROVAL_JOBS
Object Type: TABLE
Owner: ICX
FND Design Data: TableICX.ICX_POR_BUYER_APPROVAL_JOBS
Subobject Name:
Status: VALID


Holds detail information on Buyer Pricing Approval/Rejection batch processes. This is a subtable of the ICX_POR_BATCH_JOBS table. The data it stores include the internal identifier for the price list with approval pending lines, the action to be performed i.e. whether to approve or reject, comments if the user selected to reject and the max_published_date to be used as a means of concurrency control for multiple approval/rejection jobs taking place at the same time against the same price list. The max_published_date determines the latest price line to be approved or rejected by this job.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
ICX_POR_BUYER_AJ_U1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnJOB_NUMBER
Columns
Name Datatype Length Mandatory Comments
JOB_NUMBER NUMBER
Yes Job Number assigned to the process for Approval or Rejection of Buyer Specific Prices.
PRICE_LIST_HEADER_ID NUMBER
Yes Unique identifier for a Price List
MAX_PUBLISHED_DATE DATE
Yes Max Published date used to handle concurrency for the case of 2 or more jobs trying to Approve/Reject lines on the same Price List.
ACTION VARCHAR2 (30) Yes Action requested by the user. Possible values are APPROVE or REJECT.
COMMENTS VARCHAR2 (2000)
Comments used to justify rejecting Price Lines.
Query Text

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


SELECT JOB_NUMBER
,      PRICE_LIST_HEADER_ID
,      MAX_PUBLISHED_DATE
,      ACTION
,      COMMENTS
FROM ICX.ICX_POR_BUYER_APPROVAL_JOBS;

Dependencies

[top of page]

ICX.ICX_POR_BUYER_APPROVAL_JOBS does not reference any database object

ICX.ICX_POR_BUYER_APPROVAL_JOBS is referenced by following:

SchemaAPPS
SynonymICX_POR_BUYER_APPROVAL_JOBS