FND Design Data [Home] [Help]

View: PA_INVOICE_SCHEDULES_LOV_V

Product: PA - Projects
Description:
Implementation/DBA Data: ViewAPPS.PA_INVOICE_SCHEDULES_LOV_V
View Text

SELECT IRS.IND_RATE_SCH_ID
, IRS.IND_RATE_SCH_NAME
FROM PA_IND_RATE_SCHEDULES IRS
WHERE IRS.PROJECT_ID IS NULL
AND TRUNC(SYSDATE) BETWEEN TRUNC(IRS.START_DATE_ACTIVE )
AND NVL (IRS.END_DATE_ACTIVE
, TRUNC(SYSDATE)) ORDER BY 1

Columns

Name
INV_IND_RATE_SCH_ID
INVOICE_RATE_SCHEDULE