SP_KKXPBU_OPRVW (SQL View)	Index Back
Budg Business Unit Prompt VW Prompt View of the Budget Business Unit given the Commitment Control Tran Id and Tran Dt. Used on the Transaction Header Exception Panel.

SP_KKXPBU_OPRVW

(SQL View)

Budg Business Unit Prompt VW

Prompt View of the Budget Business Unit given the Commitment Control Tran Id and Tran Dt. Used on the Transaction Header Exception Panel.

SELECT DISTINCT A.OPRID ,B.KK_TRAN_ID , B.KK_TRAN_DT , B.BUSINESS_UNIT FROM PS_KK_EXCPTN_TBL B ,PS_SEC_BU_OPR A WHERE A.BUSINESS_UNIT = B.BUSINESS_UNIT

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).

2 KK_TRAN_ID Character(10) VARCHAR2(10) NOT NULL Commitment Control Foreign Key for Transaction Identification.

3 KK_TRAN_DT Date(10) DATE Commitment Control Transaction Original processing date. Primary key with KK_TRAN_ID.

4 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
2	KK_TRAN_ID	Character(10)	VARCHAR2(10) NOT NULL	Commitment Control Foreign Key for Transaction Identification.
3	KK_TRAN_DT	Date(10)	DATE	Commitment Control Transaction Original processing date. Primary key with KK_TRAN_ID.
4	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit