[Home] [Help]
View: PA_VENDORS_RES_V
View Text
SELECT VENDOR_ID
, VENDOR_NAME
, 'N'
, NULL
, 'N'
FROM PO_VENDORS
WHERE DECODE(PA_GET_RESOURCE.INCLUDE_INACTIVE_RESOURCES
, 'Y'
, NVL(START_DATE_ACTIVE
, TRUNC(SYSDATE))
, TRUNC(SYSDATE)) BETWEEN NVL(START_DATE_ACTIVE
, TRUNC(SYSDATE))
AND NVL(END_DATE_ACTIVE
, TRUNC(SYSDATE))
Columns
Name |
VENDOR_ID |
VENDOR_NAME |
TRACK_AS_LABOR_FLAG |
UNIT_OF_MEASURE |
ROLLUP_QUANTITY_FLAG |