Product: | CSP - Spares Management |
---|---|
Description: | Picklist header information |
Implementation/DBA Data: | APPS.CSP_PICKLIST_HEADERS_V |
SELECT CPLH.ROWID
, CPLH.PICKLIST_HEADER_ID
, CPLH.CREATED_BY
, CPLH.CREATION_DATE
, CPLH.LAST_UPDATED_BY
, CPLH.LAST_UPDATE_DATE
, CPLH.LAST_UPDATE_LOGIN
, CPLH.ORGANIZATION_ID
, CPLH.PICKLIST_NUMBER
, CPLH.PICKLIST_STATUS
, CPLH.DATE_CREATED
, CPLH.DATE_CONFIRMED
, CPLH.ATTRIBUTE_CATEGORY
, CPLH.ATTRIBUTE1
, CPLH.ATTRIBUTE2
, CPLH.ATTRIBUTE3
, CPLH.ATTRIBUTE4
, CPLH.ATTRIBUTE5
, CPLH.ATTRIBUTE6
, CPLH.ATTRIBUTE7
, CPLH.ATTRIBUTE8
, CPLH.ATTRIBUTE9
, CPLH.ATTRIBUTE10
, CPLH.ATTRIBUTE11
, CPLH.ATTRIBUTE12
, CPLH.ATTRIBUTE13
, CPLH.ATTRIBUTE14
, CPLH.ATTRIBUTE15
, FL.MEANING
FROM CSP_PICKLIST_HEADERS CPLH
, FND_LOOKUPS FL
WHERE CPLH.PICKLIST_STATUS = FL.LOOKUP_CODE(+) AND FL.LOOKUP_TYPE = 'CSP_PICKLIST_STATUS'