Thursday, 25 May 2023

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/]

No comments:

Post a Comment