View: JAI_PO_VENDOR_NAMES_V

Product:	JA - Asia/Pacific Localizations
Description:
Implementation/DBA Data:	APPS.JAI_PO_VENDOR_NAMES_V

View Text

SELECT VENDOR_NAME
, SEGMENT1
, DECODE(HOLD_FLAG
, 'Y'
, '*'
, NULL) HOLD
, VENDOR_ID
FROM PO_VENDORS
WHERE ENABLED_FLAG = 'Y'
AND TRUNC(SYSDATE) BETWEEN NVL(START_DATE_ACTIVE
, SYSDATE-1)
AND NVL(END_DATE_ACTIVE
, SYSDATE+1) UNION ALL SELECT ORGN.ORGANIZATION_NAME
, ORGN.ORGANIZATION_CODE
, 'Y'
, -1* ORGN.ORGANIZATION_ID
FROM ORG_ORGANIZATION_DEFINITIONS ORGN
WHERE EXISTS ( SELECT 1
FROM JAI_CMN_INVENTORY_ORGS JHRO
WHERE JHRO.ORGANIZATION_ID = ORGN.ORGANIZATION_ID )

Columns