INTFC_OM_BLL_VW

(SQL View)
 Index Back

View of pending Cred Card Tran

Prompt view of OM Pending Credit Card Transactions Bill To Customers. Date Init. Issue # Description 040103 JJM 53855000 Created record

SELECT DISTINCT IC.BUSINESS_UNIT , OH.BILL_TO_CUST_ID , CS.NAME1 FROM PS_INTFC_CRCARD IC , PS_ORD_HEADER OH , PS_CUSTOMER CS WHERE IC.BUSINESS_UNIT = OH.BUSINESS_UNIT AND IC.ORDER_NO = OH.ORDER_NO AND CS.CUST_STATUS IN ('A','I') AND CS.SETID = ( SELECT SCR.SETID FROM PS_SET_CNTRL_REC SCR WHERE SCR.SETCNTRLVALUE = OH.BUSINESS_UNIT AND SCR.RECNAME = 'CUSTOMER') AND CS.CUST_ID = OH.BILL_TO_CUST_ID AND IC.PROCESS_INSTANCE = 0 AND IC.INVOICE = ' ' AND IC.DEPOSIT_ID = ' ' AND IC.ORDER_NO <> ' '

  • Related Language Record: INTFC_OM_BLL_LN

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

    2 BILL_TO_CUST_ID Character(15) VARCHAR2(15) NOT NULL Customer
    3 NAME2 Character(40) VARCHAR2(40) NOT NULL Name 2