BI Publisher (MOSC)

MOSC Banner

Total Amount * 1.105 in rtf template in EBS

edited Dec 4, 2017 7:09AM in BI Publisher (MOSC) 3 commentsAnswered

Hi All,

I have rtf template in EBS Bi publisher,

Total Amount is printing based on the below conditions.

<?if: TERM_NAME != 'Credit Card'  and CF_DEPOSIT_NUMBER != '' and sum(LINE_EXTENDED_AMOUNT)=0 and TRX_TYPE= 'CM'?><?sum(LINE_EXTENDED_AMOUNT) +sum(TAX_RECOVERABLE)+CF_FRIEGHT_TAX?><?end if?><?if: TERM_NAME != 'Credit Card'  and CF_DEPOSIT_NUMBER != '' and sum(LINE_EXTENDED_AMOUNT)!=0  and TRX_TYPE= 'CM'?><?sum(LINE_EXTENDED_AMOUNT)+sum(TAX_RECOVERABLE) +xdoxslt:get_variable($_XDOCTX, 'Commitment_applied') ?><?end if?><?if: TERM_NAME != 'Credit Card' and CF_DEPOSIT_NUMBER = '' and TRX_TYPE != 'CM' ?><?sum(LINE_EXTENDED_AMOUNT) +sum(TAX_RECOVERABLE)  +sum(CP_SHIPPING_CHARGES)  +sum(CP_FREIGHT_TAX)+CF_FRIEGHT_TAX+CF_SHIPPING_ADDRESS?> <?end if?><?if: TERM_NAME != 'Credit Card' and CF_DEPOSIT_NUMBER != '' and TRX_TYPE != 'CM' and sum(LINE_EXTENDED_AMOUNT)!=0?><?sum(LINE_EXTENDED_AMOUNT) +sum(TAX_RECOVERABLE)  +sum(CP_SHIPPING_CHARGES)  +sum(CP_FREIGHT_TAX)+xdoxslt:get_variable($_XDOCTX, 'Commitment_applied')?>  <?end if?><?if: TERM_NAME != 'Credit Card' and CF_DEPOSIT_NUMBER != '' and TRX_TYPE != 'CM' and sum(LINE_EXTENDED_AMOUNT)=0?><?sum(LINE_EXTENDED_AMOUNT) +sum(TAX_RECOVERABLE)  +sum(CP_SHIPPING_CHARGES)  +sum(CP_FREIGHT_TAX)?><?end if?><?if:TRX_TYPE != 'CM' and  TERM_NAME = 'Credit Card'?><?CF_AMNT_DUE_REM?><?end if?><?if: TERM_NAME != 'Credit

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center