Commitment Control>Budget Transfers>Lines: PC BU Prompt Table Lookup
SQL associated with the view:
SELECT DISTINCT B.BUSINESS_UNIT_GL
, %Substring(A.SETCNTRLVALUE, 1, 5)
, %Substring(A.SETCNTRLVALUE, 1, 5)
, D.DESCR
FROM PS_SET_CNTRL_REC A
, PS_PC_INT_TMPL_GL B
, PS_BUS_UNIT_TBL_FS D
WHERE A.SETID = B.SETID
AND A.RECNAME = 'PC_INT_TMPL_GL'
AND D.BUSINESS_UNIT = A.SETCNTRLVALUE