INTFC_OM_CST_LN

(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. Date Init Issue # Description 082101 JJM F-CJORGENS-6 Added ORDER_NO, SOLD_TO_CUST_ID and CR_CARD_AUTH_STAT 040103 JJM 53855000 Added SOLD_TO_CUST_ID, NAME1 and NAME2

SELECT IC.BUSINESS_UNIT , IC.ORDER_NO , CL1.LANGUAGE_CD , CL1.NAME1 , CL2.NAME1 FROM PS_INTFC_CRCARD IC , PS_ORD_HEADER OH , PS_CUSTOMER_LANG CL1 , PS_CUSTOMER_LANG CL2 WHERE IC.BUSINESS_UNIT = OH.BUSINESS_UNIT AND IC.ORDER_NO = OH.ORDER_NO AND CL1.SETID = ( SELECT SCR.SETID FROM PS_SET_CNTRL_REC SCR WHERE SCR.SETCNTRLVALUE = OH.BUSINESS_UNIT AND SCR.RECNAME = 'CUSTOMER') AND CL1.CUST_ID = OH.SOLD_TO_CUST_ID AND CL2.SETID = CL1.SETID AND CL2.CUST_ID = OH.BILL_TO_CUST_ID AND CL2.LANGUAGE_CD = CL1.LANGUAGE_CD AND IC.PROCESS_INSTANCE = 0 AND IC.INVOICE = ' ' AND IC.DEPOSIT_ID = ' ' AND IC.ORDER_NO <> ' '

  • Related Language Record for INTFC_OM_CST_VW
  • # 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 ORDER_NO Character(10) VARCHAR2(10) NOT NULL Identifies a customer order number that appears as a reference on a receivables pending item. Date Initials Issue Description 022701 mv SP2 (F-CJORGENS-3) CSR Desktop
    3 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    4 NAME1 Character(40) VARCHAR2(40) NOT NULL Name 1
    5 NAME2 Character(40) VARCHAR2(40) NOT NULL Name 2