Need help with defaulting a value to DFF on Service Contract Lines
I am trying to default the value of ATTRIBUTE5 from HZ_CUST_ACCOUNTS for the value of the CUST_ACCT_ID found on the Service Contract Line. I thought I had it working with this SQL Statement for defaulting:
select NVL(hzca.attribute5,NULL) from hz_cust_accounts hzca, OKS_AUTH_LINES_V oksalv
where oksalv.chr_id = NVL(decode(:system.current_block:null, 'OKC_LINES',
:okc_lines.chr_id:null, NULL),oksalv.chr_id)
and oksalv.line_number = NVL(decode(:system.current_block:null, 'OKC_LINES',
:okc_lines.line_number:null, NULL),oksalv.line_number)
and oksalv.cust_acct_id = hzca.cust_account_id
select NVL(hzca.attribute5,NULL) from hz_cust_accounts hzca, OKS_AUTH_LINES_V oksalv
where oksalv.chr_id = NVL(decode(:system.current_block:null, 'OKC_LINES',
:okc_lines.chr_id:null, NULL),oksalv.chr_id)
and oksalv.line_number = NVL(decode(:system.current_block:null, 'OKC_LINES',
:okc_lines.line_number:null, NULL),oksalv.line_number)
and oksalv.cust_acct_id = hzca.cust_account_id
0