[Home] [Help] [Dependency Information]
Object Name: | PA_TRANSACTION_XFACE_CTRL_ALL# |
---|---|
Object Type: | VIEW |
Owner: | PA |
Subobject Name: | |
Status: | VALID |
A multi-org view which will retrive data for your current operating unit and ignore data in other operating units.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
TRANSACTION_SOURCE | VARCHAR2 | (30) | Yes | |
BATCH_NAME | VARCHAR2 | (240) | Yes | |
STATUS | VARCHAR2 | (30) | Yes | |
INTERFACE_ID | NUMBER | (15) | ||
TRANSACTION_COUNT | NUMBER | Yes | ||
ORG_ID | NUMBER | (15) | ||
SYSTEM_LINKAGE_FUNCTION | VARCHAR2 | (3) | Yes | |
TRANSACTION_STATUS_CODE | VARCHAR2 | (2) | ||
PRE_IMPORT_REJECT_COUNT | NUMBER | |||
PRE_IMPORT_SUCCESS_COUNT | NUMBER | |||
IMPORT_REJECT_COUNT | NUMBER | |||
IMPORT_SUCCESS_COUNT | NUMBER | |||
POST_IMPORT_REJECT_COUNT | NUMBER | |||
POST_IMPORT_SUCCESS_COUNT | NUMBER | |||
INTERMEDIATE_FLAG | VARCHAR2 | (1) | [Flag that indicates not all records in this batch has been processed. | |
PROCESSED_COUNT | NUMBER | Number of processed records |
Cut, paste (and edit) the following text to query this object:
SELECT TRANSACTION_SOURCE
, BATCH_NAME
, STATUS
, INTERFACE_ID
, TRANSACTION_COUNT
, ORG_ID
, SYSTEM_LINKAGE_FUNCTION
, TRANSACTION_STATUS_CODE
, PRE_IMPORT_REJECT_COUNT
, PRE_IMPORT_SUCCESS_COUNT
, IMPORT_REJECT_COUNT
, IMPORT_SUCCESS_COUNT
, POST_IMPORT_REJECT_COUNT
, POST_IMPORT_SUCCESS_COUNT
, INTERMEDIATE_FLAG
, PROCESSED_COUNT
FROM PA.PA_TRANSACTION_XFACE_CTRL_ALL#;
|
|
|