INTFC_OM_SR_VW (SQL View)	Index Back
View of pending Cred Card Tran View of Order Management Pending Credit Card Transactions. These can be where the transactions have not processed or if they have been denied.

INTFC_OM_SR_VW

(SQL View)

View of pending Cred Card Tran

View of Order Management Pending Credit Card Transactions. These can be where the transactions have not processed or if they have been denied.

SELECT BUSINESS_UNIT FROM PS_INTFC_CRCARD WHERE PROCESS_INSTANCE = 0 AND INVOICE = ' ' AND DEPOSIT_ID = ' ' AND ORDER_NO <> ' '

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
Default Value: OPR_DEF_TBL_OM.BUSINESS_UNIT
Prompt Table: SP_BU_OM_NONVW