Product: | IGW - Grants Proposal |
---|---|
Description: | 10SC Only |
Implementation/DBA Data: | APPS.IGW_IMPLEMENTATIONS |
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)