VIEW: APPS.JAI_PO_VENDOR_NAMES_V

Source

View Text - Preformatted

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 )

View Text - HTML Formatted

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 )