[Home] [Help]
[Dependency Information]
Object Name: | PO_MASSCANCEL_INCLUDES_ALL |
---|---|
Object Type: | TABLE |
Owner: | PO |
FND Design Data: | ![]() |
Subobject Name: | |
Status: | VALID |
PO_MASSCANCEL_INCLUDES_ALL stores ranges of Accounting Flexfields for
which you want to cancel purchase orders or requisitions using
MassCancel.
MassCancel selects purchase orders or requisitions for cancellation
which have at least one distribution within the Accounting Flexfield
ranges you specify and which meet your other cancellation criteria.
.
Your segment values of your cancellation ranges are stored in the
SEGMENTn_HIGH and SEGMENTn_LOW columns, where n is a number from 1 to
30.
OBJECT_TYPE and OBJECT_NUMBER provide the document type (REQUISITION,
STANDARD, PLANNED or BLANKET) and transaction number of your
document.
.
Tablespace: | ![]() |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
PO_MASSCANCEL_INCLUDES_N1 | NORMAL | NONUNIQUE |
![]() |
![]() |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
NAME | VARCHAR2 | (80) | Yes | Masscancel batch name |
LAST_UPDATE_DATE | DATE | Yes | Standard Who column - date when a user last updated this row. | |
LAST_UPDATED_BY | NUMBER | Yes | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). | |
INCLUDE_LOW | VARCHAR2 | (240) | Yes | Low accounting flexfield value for the range |
INCLUDE_HIGH | VARCHAR2 | (240) | Yes | High accounting flexfield value for the range |
LAST_UPDATE_LOGIN | NUMBER | 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 | Standard who column - user who created this row (foreign key to FND_USER.USER_ID). | ||
SEGMENT1_LOW | VARCHAR2 | (25) | Minimum value for the corresponding segment of the Accounting Flexfield | |
SEGMENT1_HIGH | VARCHAR2 | (25) | Maximum value for the corresponding segment of the Accounting Flexfield | |
SEGMENT2_LOW | VARCHAR2 | (25) | Minimum value for the corresponding segment of the Accounting Flexfield | |
SEGMENT2_HIGH | VARCHAR2 | (25) | Maximum value for the corresponding segment of the Accounting Flexfield | |
SEGMENT3_LOW | VARCHAR2 | (25) | Minimum value for the corresponding segment of the Accounting Flexfield | |
SEGMENT3_HIGH | VARCHAR2 | (25) | Maximum value for the corresponding segment of the Accounting Flexfield | |
SEGMENT4_LOW | VARCHAR2 | (25) | Minimum value for the corresponding segment of the Accounting Flexfield | |
SEGMENT4_HIGH | VARCHAR2 | (25) | Maximum value for the corresponding segment of the Accounting Flexfield | |
SEGMENT5_LOW | VARCHAR2 | (25) | Minimum value for the corresponding segment of the Accounting Flexfield | |
SEGMENT5_HIGH | VARCHAR2 | (25) | Maximum value for the corresponding segment of the Accounting Flexfield | |
SEGMENT6_LOW | VARCHAR2 | (25) | Minimum value for the corresponding segment of the Accounting Flexfield | |
SEGMENT6_HIGH | VARCHAR2 | (25) | Maximum value for the corresponding segment of the Accounting Flexfield | |
SEGMENT7_LOW | VARCHAR2 | (25) | Minimum value for the corresponding segment of the Accounting Flexfield | |
SEGMENT7_HIGH | VARCHAR2 | (25) | Maximum value for the corresponding segment of the Accounting Flexfield | |
SEGMENT8_LOW | VARCHAR2 | (25) | Minimum value for the corresponding segment of the Accounting Flexfield | |
SEGMENT8_HIGH | VARCHAR2 | (25) | Maximum value for the corresponding segment of the Accounting Flexfield | |
SEGMENT9_LOW | VARCHAR2 | (25) | Minimum value for the corresponding segment of the Accounting Flexfield | |
SEGMENT9_HIGH | VARCHAR2 | (25) | Maximum value for the corresponding segment of the Accounting Flexfield | |
SEGMENT10_LOW | VARCHAR2 | (25) | Minimum value for the corresponding segment of the Accounting Flexfield | |
SEGMENT10_HIGH | VARCHAR2 | (25) | Maximum value for the corresponding segment of the Accounting Flexfield | |
SEGMENT11_LOW | VARCHAR2 | (25) | Minimum value for the corresponding segment of the Accounting Flexfield | |
SEGMENT11_HIGH | VARCHAR2 | (25) | Maximum value for the corresponding segment of the Accounting Flexfield | |
SEGMENT12_LOW | VARCHAR2 | (25) | Minimum value for the corresponding segment of the Accounting Flexfield | |
SEGMENT12_HIGH | VARCHAR2 | (25) | Maximum value for the corresponding segment of the Accounting Flexfield | |
SEGMENT13_LOW | VARCHAR2 | (25) | Minimum value for the corresponding segment of the Accounting Flexfield | |
SEGMENT13_HIGH | VARCHAR2 | (25) | Maximum value for the corresponding segment of the Accounting Flexfield | |
SEGMENT14_LOW | VARCHAR2 | (25) | Minimum value for the corresponding segment of the Accounting Flexfield | |
SEGMENT14_HIGH | VARCHAR2 | (25) | Maximum value for the corresponding segment of the Accounting Flexfield | |
SEGMENT15_LOW | VARCHAR2 | (25) | Minimum value for the corresponding segment of the Accounting Flexfield | |
SEGMENT15_HIGH | VARCHAR2 | (25) | Maximum value for the corresponding segment of the Accounting Flexfield | |
SEGMENT16_LOW | VARCHAR2 | (25) | Minimum value for the corresponding segment of the Accounting Flexfield | |
SEGMENT16_HIGH | VARCHAR2 | (25) | Maximum value for the corresponding segment of the Accounting Flexfield | |
SEGMENT17_LOW | VARCHAR2 | (25) | Minimum value for the corresponding segment of the Accounting Flexfield | |
SEGMENT17_HIGH | VARCHAR2 | (25) | Maximum value for the corresponding segment of the Accounting Flexfield | |
SEGMENT18_LOW | VARCHAR2 | (25) | Minimum value for the corresponding segment of the Accounting Flexfield | |
SEGMENT18_HIGH | VARCHAR2 | (25) | Maximum value for the corresponding segment of the Accounting Flexfield | |
SEGMENT19_LOW | VARCHAR2 | (25) | Minimum value for the corresponding segment of the Accounting Flexfield | |
SEGMENT19_HIGH | VARCHAR2 | (25) | Maximum value for the corresponding segment of the Accounting Flexfield | |
SEGMENT20_LOW | VARCHAR2 | (25) | Minimum value for the corresponding segment of the Accounting Flexfield | |
SEGMENT20_HIGH | VARCHAR2 | (25) | Maximum value for the corresponding segment of the Accounting Flexfield | |
SEGMENT21_LOW | VARCHAR2 | (25) | Minimum value for the corresponding segment of the Accounting Flexfield | |
SEGMENT21_HIGH | VARCHAR2 | (25) | Maximum value for the corresponding segment of the Accounting Flexfield | |
SEGMENT22_LOW | VARCHAR2 | (25) | Minimum value for the corresponding segment of the Accounting Flexfield | |
SEGMENT22_HIGH | VARCHAR2 | (25) | Maximum value for the corresponding segment of the Accounting Flexfield | |
SEGMENT23_LOW | VARCHAR2 | (25) | Minimum value for the corresponding segment of the Accounting Flexfield | |
SEGMENT23_HIGH | VARCHAR2 | (25) | Maximum value for the corresponding segment of the Accounting Flexfield | |
SEGMENT24_LOW | VARCHAR2 | (25) | Minimum value for the corresponding segment of the Accounting Flexfield | |
SEGMENT24_HIGH | VARCHAR2 | (25) | Maximum value for the corresponding segment of the Accounting Flexfield | |
SEGMENT25_LOW | VARCHAR2 | (25) | Minimum value for the corresponding segment of the Accounting Flexfield | |
SEGMENT25_HIGH | VARCHAR2 | (25) | Maximum value for the corresponding segment of the Accounting Flexfield | |
SEGMENT26_LOW | VARCHAR2 | (25) | Minimum value for the corresponding segment of the Accounting Flexfield | |
SEGMENT26_HIGH | VARCHAR2 | (25) | Maximum value for the corresponding segment of the Accounting Flexfield | |
SEGMENT27_LOW | VARCHAR2 | (25) | Minimum value for the corresponding segment of the Accounting Flexfield | |
SEGMENT27_HIGH | VARCHAR2 | (25) | Maximum value for the corresponding segment of the Accounting Flexfield | |
SEGMENT28_LOW | VARCHAR2 | (25) | Minimum value for the corresponding segment of the Accounting Flexfield | |
SEGMENT28_HIGH | VARCHAR2 | (25) | Maximum value for the corresponding segment of the Accounting Flexfield | |
SEGMENT29_LOW | VARCHAR2 | (25) | Minimum value for the corresponding segment of the Accounting Flexfield | |
SEGMENT29_HIGH | VARCHAR2 | (25) | Maximum value for the corresponding segment of the Accounting Flexfield | |
SEGMENT30_LOW | VARCHAR2 | (25) | Minimum value for the corresponding segment of the Accounting Flexfield | |
SEGMENT30_HIGH | VARCHAR2 | (25) | Maximum value for the corresponding segment of the Accounting Flexfield | |
REQUEST_ID | NUMBER | Concurrent Program who column - concurrent request id of the program that last updated this row (foreign key to FND_CONCURRENT_REQUESTS.REQUEST_ID). | ||
PROGRAM_APPLICATION_ID | NUMBER | Concurrent Program who column - application id of the program that last updated this row (foreign key to FND_APPLICATION.APPLICATION_ID). | ||
PROGRAM_ID | NUMBER | Concurrent Program who column - program id of the program that last updated this row (foreign key to FND_CONCURRENT_PROGRAM.CONCURRENT_PROGRAM_ID). | ||
PROGRAM_UPDATE_DATE | DATE | Concurrent Program who column - date when a program last updated this row). | ||
ORG_ID | NUMBER | Organization identifier |
Cut, paste (and edit) the following text to query this object:
SELECT NAME
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, INCLUDE_LOW
, INCLUDE_HIGH
, LAST_UPDATE_LOGIN
, CREATION_DATE
, CREATED_BY
, SEGMENT1_LOW
, SEGMENT1_HIGH
, SEGMENT2_LOW
, SEGMENT2_HIGH
, SEGMENT3_LOW
, SEGMENT3_HIGH
, SEGMENT4_LOW
, SEGMENT4_HIGH
, SEGMENT5_LOW
, SEGMENT5_HIGH
, SEGMENT6_LOW
, SEGMENT6_HIGH
, SEGMENT7_LOW
, SEGMENT7_HIGH
, SEGMENT8_LOW
, SEGMENT8_HIGH
, SEGMENT9_LOW
, SEGMENT9_HIGH
, SEGMENT10_LOW
, SEGMENT10_HIGH
, SEGMENT11_LOW
, SEGMENT11_HIGH
, SEGMENT12_LOW
, SEGMENT12_HIGH
, SEGMENT13_LOW
, SEGMENT13_HIGH
, SEGMENT14_LOW
, SEGMENT14_HIGH
, SEGMENT15_LOW
, SEGMENT15_HIGH
, SEGMENT16_LOW
, SEGMENT16_HIGH
, SEGMENT17_LOW
, SEGMENT17_HIGH
, SEGMENT18_LOW
, SEGMENT18_HIGH
, SEGMENT19_LOW
, SEGMENT19_HIGH
, SEGMENT20_LOW
, SEGMENT20_HIGH
, SEGMENT21_LOW
, SEGMENT21_HIGH
, SEGMENT22_LOW
, SEGMENT22_HIGH
, SEGMENT23_LOW
, SEGMENT23_HIGH
, SEGMENT24_LOW
, SEGMENT24_HIGH
, SEGMENT25_LOW
, SEGMENT25_HIGH
, SEGMENT26_LOW
, SEGMENT26_HIGH
, SEGMENT27_LOW
, SEGMENT27_HIGH
, SEGMENT28_LOW
, SEGMENT28_HIGH
, SEGMENT29_LOW
, SEGMENT29_HIGH
, SEGMENT30_LOW
, SEGMENT30_HIGH
, REQUEST_ID
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
, ORG_ID
FROM PO.PO_MASSCANCEL_INCLUDES_ALL;
PO.PO_MASSCANCEL_INCLUDES_ALL does not reference any database object
PO.PO_MASSCANCEL_INCLUDES_ALL is referenced by following:
|
|
|