View: IGW_IMPLEMENTATIONS

Product:	IGW - Grants Proposal
Description:	10SC Only
Implementation/DBA Data:	APPS.IGW_IMPLEMENTATIONS

View Text

SELECT PROPOSAL_NUMBERING_METHOD
, MANUAL_PROPOSAL_NUMB_METHOD
, NEXT_AUTOMATIC_PROPOSAL_NUMBER
, OH_EXPENDITURE_FLAG
, OH_EXPENDITURE_CATEGORY_TYPE
, UNM_EXPENDITURE_FLAG
, UNM_EXPENDITURE_CATEGORY_TYPE
, PRP_ORG_STRUCTURE_ID
, PRP_ORG_STRUCTURE_VERSION_ID
, PRP_ORG_STRUCTURE_START_ID
, APR_ORG_STRUCTURE_ID
, APR_ORG_STRUCTURE_VERSION_ID
, APR_ORG_STRUCTURE_START_ID
, BUSINESS_GROUP_ID
, ORG_ID
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_LOGIN
FROM IGW_IMPLEMENTATIONS_ALL
WHERE NVL(ORG_ID
, NVL(TO_NUMBER(DECODE(SUBSTRB(USERENV('CLIENT_INFO')
, 1
, 1)
, ' '
, NULL
, SUBSTRB(USERENV('CLIENT_INFO')
, 1
, 10)))
, -99)) = NVL(TO_NUMBER(DECODE(SUBSTRB(USERENV('CLIENT_INFO')
, 1
, 1)
, ' '
, NULL
, SUBSTRB(USERENV('CLIENT_INFO')
, 1
, 10)))
, -99)

Columns