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

VIEW: PA.PA_TRANSACTION_XFACE_CTRL_ALL#

Object Details
Object Name: PA_TRANSACTION_XFACE_CTRL_ALL#
Object Type: VIEW
Owner: PA
Subobject Name:
Status: VALID

View Type

A multi-org view which will retrive data for your current operating unit and ignore data in other operating units.

[View Source]

Columns
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
Query Text

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#;

Dependencies

[top of page]

PA.PA_TRANSACTION_XFACE_CTRL_ALL# references the following:

SchemaPA
TablePA_TRANSACTION_XFACE_CTRL_ALL
PA.PA_TRANSACTION_XFACE_CTRL_ALL# is referenced by following:

SchemaAPPS
SynonymPA_TRANSACTION_XFACE_CONTROL
SynonymPA_TRANSACTION_XFACE_CTRL_ALL