VIEW: APPS.OPI_INV_CC_LVL_V

Source

View Text - Preformatted

SELECT (cc_hdr.cycle_count_header_ID||'-' || cc_hdr.ORGANIZATION_ID) ID, (cc_hdr.cycle_count_header_name||'(' || mp.ORGANIZATION_CODE || ')') VALUE, cc_hdr.description DESCRIPTION, cc_hdr.organization_id ORG_ID from mtl_cycle_count_headers cc_hdr, mtl_parameters mp WHERE mp.organization_id = cc_hdr.organization_id union all select lookup_code ID, meaning VALUE, description DESCRIPTION, Null ORG_ID from fnd_lookup_values where lookup_type = 'OPI_DBI_SUBINV' and lookup_code = '-1' and language = userenv('LANG')

View Text - HTML Formatted

SELECT (CC_HDR.CYCLE_COUNT_HEADER_ID||'-' || CC_HDR.ORGANIZATION_ID) ID
, (CC_HDR.CYCLE_COUNT_HEADER_NAME||'(' || MP.ORGANIZATION_CODE || ')') VALUE
, CC_HDR.DESCRIPTION DESCRIPTION
, CC_HDR.ORGANIZATION_ID ORG_ID
FROM MTL_CYCLE_COUNT_HEADERS CC_HDR
, MTL_PARAMETERS MP
WHERE MP.ORGANIZATION_ID = CC_HDR.ORGANIZATION_ID UNION ALL SELECT LOOKUP_CODE ID
, MEANING VALUE
, DESCRIPTION DESCRIPTION
, NULL ORG_ID
FROM FND_LOOKUP_VALUES
WHERE LOOKUP_TYPE = 'OPI_DBI_SUBINV'
AND LOOKUP_CODE = '-1'
AND LANGUAGE = USERENV('LANG')