PP_SEARCH_VW

(SQL View)
Index Back

SELECT DISTINCT P.DEPOSIT_BU FROM PS_PAYMENT P , PS_DEPOSIT_CONTROL D WHERE (P.PP_METHOD <> ' ' OR P.PP_RQ <> 0) AND D.DEP_POST_STATUS <> 'C' AND P.PP_STATUS <> 'N'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 DEPOSIT_BU Character(5) VARCHAR2(5) NOT NULL Identifies the business unit to which a deposit is posted.

Default Value: OPR_DEF_TBL_AR.DEPOSIT_BU

Prompt Table: SP_BUARDE_NONVW