Get the column or Table information in oracle fusion erp

 select * from all_tab_cols where upper(column_name) like 'OFFSET_TAX_FLAG'

SELECT * FROM all_tab_modifications;

<?choose:?><?when: P_INVOICENUM=’’?>All<?end when?><?otherwise:?><?P_INVOICENUM?><?end otherwise?><?end choose?>

<fo:basic-link external-destination="{INVOICE_URL}" color="blue" text-decoration="underline">
<?INVOICE_NUMBER?>
</fo:basic-link>

Print Parameters In Otbi:

[b]Legal Employer               : @{PV_LE}[/b][br/]
[b]Department                      : @{PV_DEPT_NAME}[/b][br/]
[b]Employee Number            : @{PV_EMP_NUMBER}[/b][br/]
[b]Start Date                          : @{PV_ST_DT}[/b][br/]
[b]End Date                            : @{PV_END_DT}[/b][br/]
[b]Leave Type                           : @{PV_ABS_TYPE}[/b][br/]
[b]Absence Status                        : @{PV_ABS_STA}[/b][br/]

Convert String into Arabic xml tag for RTF:

<?xdoxslt:toCheckNumber('AR-KW',SALARY_AMOUNT,0)?>

IF condition in RTF xml Tag:

1) <?if:(GRADE='8 A') or 

(GRADE='8 B') or (GRADE='9 A') or (GRADE='9 B') or 

(GRADE='10 A') or (GRADE='10 B') or (GRADE='11 A') or 

(GRADE='11 B') or (GRADE='12')?>

2)<?xdofx:if (GRADE ='8 A' or GRADE ='8 B')

Then '2000'

Else If (GRADE ='9 A' or GRADE ='9 B')

Then '2500'

Else If (GRADE ='10 A' or GRADE ='10 B')

Then '2800'

Else If (GRADE ='11 A' or GRADE ='11 B')

Then '3500'

Else If (GRADE ='12')

Then '5000'

END if?>

Call Subtemplate:

In Rtf Template:
<?call:Logo?>
<?import:xdoxsl:///Custom/Custom/Financials/Payables/Reports/Logo Template.xsb(Report Path)?>

In Fusion Sub Template:
<?template_Logo?> insert your Logo <?end template?>