SELECT
TO_CHAR (:ACCOUNTING_P_FROM_DATE, 'DD-MON-RRRR') From_GL_Date,
TO_CHAR (:ACCOUNTING_P_TO_DATE, 'DD-MON-RRRR') To_GL_Date,
NVL(:P_BU_NAME,'ALL') BU_NAME,
NVL(:P_SOURCE,'ALL') SOURCE,
TO_CHAR (:INV_P_FROM_DATE, 'DD-MON-RRRR') From_Invoice_Date,
TO_CHAR (:INV_P_TO_DATE, 'DD-MON-RRRR') To_Invoice_Date,
TO_CHAR (SYSDATE + 3/24, 'DD-MM-YYYY HH12:MI:SS AM') PRINT_DATE,
to_char(sysdate,'DD-MON-RRRR HH24:MI:SS') as RUN_DATE,
((select SUBSTR(external_virtual_host,INSTR( external_virtual_host, '-', 1,2 )+1,9) from ask_deployed_domains WHERE
deployed_domain_name='FADomain')) instance,
FND_GLOBAL.USER_NAME as RUN_BY
FROM DUAL
No comments:
Post a Comment