RF_RMA_PRPT_VW4 (SQL View)	Index Back
RMA Prompt View This is the Site prompt view for the RF_RMA component.

RF_RMA_PRPT_VW4

(SQL View)

RMA Prompt View

This is the Site prompt view for the RF_RMA component.

SELECT DISTINCT BUSINESS_UNIT , CASE_ID FROM PS_RF_RMA_HDR WHERE CASE_ID <> 0

# 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_RB.BUSINESS_UNIT
Prompt Table: SP_BU_RC_NONVW

2 CASE_ID Number(15,0) DECIMAL(15) NOT NULL Case ID. This is a unique ID assigned to a case when it is saved. Unique ID is ensured by getting the next value from the auto-numbering table and updating the table.