View: GMS_AWARDS_V

Product:	GMS - Grants Accounting
Description:	Commented the allow_query in where clause as per bug 1538406
Implementation/DBA Data:	APPS.GMS_AWARDS_V

View Text

SELECT AWD.AWARD_ID
, AWD.AWARD_NUMBER
, AWD.AWARD_TEMPLATE_FLAG
, AWD.AWARD_PROJECT_ID
, AWD.AGREEMENT_ID
, FS.CUST_ACCOUNT_ID CUSTOMER_ID
, SUBSTRB(PARTY.PARTY_NAME
, 1
, 50) CUSTOMER_NAME
, AWD.AWARD_SHORT_NAME
, AWD.FUNDING_SOURCE_AWARD_NUMBER
, AWD.AWARD_FULL_NAME
, AWD.START_DATE_ACTIVE
, AWD.END_DATE_ACTIVE
, AWD.CLOSE_DATE
, AWD.PREAWARD_DATE
, AWD.TYPE
, AWD.AWARD_PURPOSE_CODE
, LP_12.MEANING
, AWD.STATUS
, LP_2.MEANING
, AWD.ALLOWABLE_SCHEDULE_ID
, AL_SCH.ALLOW_SCH_NAME/*
, PRJ.COST_IND_RATE_SCH_ID*/
, AWD.IDC_SCHEDULE_ID/*
, AWD.IDC_SCHEDULE_NAME*/
, IRS.IND_RATE_SCH_NAME
, AWD.REVENUE_DISTRIBUTION_RULE
, AWD.BILLING_FREQUENCY
, AWD.BILLING_CYCLE_ID
, AWD.BILLING_OFFSET
, LP_4.MEANING
, AWD.BILLING_DISTRIBUTION_RULE
, AWD.BILLING_TERM
, RAT.NAME
, AWD.BILLING_FORMAT
, AWD.LABOR_INVOICE_FORMAT_ID
, INV_FMT_LAB.NAME
, AWD.NON_LABOR_INVOICE_FORMAT_ID
, INV_FMT_NONLAB.NAME
, AWD.TRANSACTION_NUMBER
, AWD.BILL_TO_CUSTOMER_ID
, SUBSTRB(PARTY1.PARTY_NAME
, 1
, 50) CUSTOMER_NAME
, AWD.AGENCY_SPECIFIC_FORM
, AGT.AGREEMENT_NUM
, AWD.HARD_LIMIT_FLAG
, AWD.FUND_CONTROL_LEVEL_AWARD
, LP_8.MEANING
, AWD.FUND_CONTROL_LEVEL_TASK
, LP_9.MEANING
, AWD.FUND_CONTROL_LEVEL_RES_GRP
, LP_10.MEANING
, AWD.FUND_CONTROL_LEVEL_RES
, LP_11.MEANING
, AWD.AMOUNT_TYPE
, LP_6.MEANING
, AWD.BOUNDARY_CODE
, LP_7.MEANING
, AWD.AWARD_ORGANIZATION_ID
, OL.NAME/*OL.DESCRIPTION*/
, SPF.TOTAL_ACCRUED_AMOUNT
, SPF.TOTAL_BILLED_AMOUNT/*
, PRJ.COST_IND_SCH_FIXED_DATE*/
, AWD.COST_IND_SCH_FIXED_DATE
, AWD.ATTRIBUTE_CATEGORY
, AWD.ATTRIBUTE1
, AWD.ATTRIBUTE2
, AWD.ATTRIBUTE3
, AWD.ATTRIBUTE4
, AWD.ATTRIBUTE5
, AWD.ATTRIBUTE6
, AWD.ATTRIBUTE7
, AWD.ATTRIBUTE8
, AWD.ATTRIBUTE9
, AWD.ATTRIBUTE10
, AWD.ATTRIBUTE11
, AWD.ATTRIBUTE12
, AWD.ATTRIBUTE13
, AWD.ATTRIBUTE14
, AWD.ATTRIBUTE15
, AWD.ATTRIBUTE16
, AWD.ATTRIBUTE17
, AWD.ATTRIBUTE18
, AWD.ATTRIBUTE19
, AWD.ATTRIBUTE20
, AWD.ATTRIBUTE21
, AWD.ATTRIBUTE22
, AWD.ATTRIBUTE23
, AWD.ATTRIBUTE24
, AWD.ATTRIBUTE25
, AWD.TEMPLATE_START_DATE_ACTIVE
, AWD.TEMPLATE_END_DATE_ACTIVE
, AWD.LAST_UPDATE_DATE
, AWD.LAST_UPDATED_BY
, AWD.CREATION_DATE
, AWD.CREATED_BY
, AWD.LAST_UPDATE_LOGIN
, AWD.ROWID
, SUBSTR(GMS_SECURITY.ALLOW_UPDATE(AWD.AWARD_ID)
, 1
, 1)
, AWD.BILL_TO_ADDRESS_ID
, AWD.SHIP_TO_ADDRESS_ID
, AWD.LOC_BILL_TO_ADDRESS_ID
, AWD.LOC_SHIP_TO_ADDRESS_ID
, AWD.BUDGET_WF_ENABLED_FLAG
, AWD.PROPOSAL_ID
, AWD.ORG_ID
, OL2.OPERATING_UNIT
FROM GMS_AWARDS AWD
, HZ_PARTIES PARTY
, HZ_CUST_ACCOUNTS FS
, HZ_PARTIES PARTY1
, HZ_CUST_ACCOUNTS BTC
, GMS_LOOKUPS LP_2
, GMS_LOOKUPS LP_3
, GMS_LOOKUPS LP_4
, GMS_LOOKUPS LP_5
, GMS_LOOKUPS LP_6
, GMS_LOOKUPS LP_7
, GMS_LOOKUPS LP_8
, GMS_LOOKUPS LP_9
, GMS_LOOKUPS LP_10
, GMS_LOOKUPS LP_11
, PA_AGREEMENTS_ALL AGT
, /*PA_PROJECTS PRJ
, */ PA_IND_RATE_SCHEDULES IRS
, GMS_ALLOWABILITY_SCHEDULES AL_SCH
, RA_TERMS RAT
, PA_INVOICE_FORMATS INV_FMT_LAB
, PA_INVOICE_FORMATS INV_FMT_NONLAB
, GMS_LOOKUPS LP_12
, /* PA_ORGANIZATIONS_LOV_V */ HR_ALL_ORGANIZATION_UNITS OL
, PA_SUMMARY_PROJECT_FUNDINGS SPF
, GMS_OPERATING_UNITS_V OL2
WHERE /*GMS_SECURITY.ALLOW_QUERY(AWD.AWARD_ID) = 'Y' */ 'Y' IN (SELECT GMS_SECURITY.ALLOW_QUERY(AWD.AWARD_ID)
FROM SYS.DUAL)
AND AWD.FUNDING_SOURCE_ID=FS.CUST_ACCOUNT_ID(+)
AND BTC.CUST_ACCOUNT_ID(+)=AWD.BILL_TO_CUSTOMER_ID
AND FS.PARTY_ID = PARTY.PARTY_ID(+)
AND BTC.PARTY_ID = PARTY1.PARTY_ID(+)
AND (LP_2.LOOKUP_TYPE(+)='AWARD_STATUS')
AND LP_2.LOOKUP_CODE(+)=AWD.STATUS
AND (LP_3.LOOKUP_TYPE(+)='REVENUE_DISTRIBUTION_RULE'
AND LP_3.LOOKUP_CODE(+)=AWD.REVENUE_DISTRIBUTION_RULE)
AND (LP_4.LOOKUP_TYPE(+)='BILLING_FREQUENCY'
AND LP_4.LOOKUP_CODE(+)=AWD.BILLING_FREQUENCY)
AND (LP_5.LOOKUP_TYPE(+)='BILLING_DISTRIBUTION_RULE'
AND LP_5.LOOKUP_CODE(+)=AWD.BILLING_DISTRIBUTION_RULE)
AND (LP_6.LOOKUP_TYPE(+)='AMOUNT_TYPE'
AND LP_6.LOOKUP_CODE(+)=AWD.AMOUNT_TYPE)
AND (LP_7.LOOKUP_TYPE(+)='BOUNDARY_CODE'
AND LP_7.LOOKUP_CODE(+)=AWD.BOUNDARY_CODE)
AND (LP_8.LOOKUP_TYPE(+)='FUND_CONTROL_LEVEL'
AND LP_8.LOOKUP_CODE(+)=AWD.FUND_CONTROL_LEVEL_AWARD)
AND (LP_9.LOOKUP_TYPE(+)='FUND_CONTROL_LEVEL'
AND LP_9.LOOKUP_CODE(+)=AWD.FUND_CONTROL_LEVEL_TASK)
AND (LP_10.LOOKUP_TYPE(+)='FUND_CONTROL_LEVEL'
AND LP_10.LOOKUP_CODE(+)=AWD.FUND_CONTROL_LEVEL_RES_GRP)
AND (LP_11.LOOKUP_TYPE(+)='FUND_CONTROL_LEVEL'
AND LP_11.LOOKUP_CODE(+)=AWD.FUND_CONTROL_LEVEL_RES) AND(LP_12.LOOKUP_TYPE(+)='AWARD_PURPOSE_CODE'
AND LP_12.LOOKUP_CODE(+)=AWD.AWARD_PURPOSE_CODE)
AND AWD.IDC_SCHEDULE_ID=IRS.IND_RATE_SCH_ID(+)
AND AWD.ALLOWABLE_SCHEDULE_ID=AL_SCH.ALLOWABILITY_SCHEDULE_ID(+)
AND AWD.BILLING_TERM=RAT.TERM_ID(+)
AND INV_FMT_LAB.INVOICE_FORMAT_ID(+)=AWD.LABOR_INVOICE_FORMAT_ID
AND INV_FMT_NONLAB.INVOICE_FORMAT_ID(+)=AWD.NON_LABOR_INVOICE_FORMAT_ID
AND AWD.AGREEMENT_ID=AGT.AGREEMENT_ID(+)
AND OL.ORGANIZATION_ID(+)=AWD.AWARD_ORGANIZATION_ID
AND SPF.AGREEMENT_ID(+)=AWD.AGREEMENT_ID
AND OL2.ORG_ID =AWD.ORG_ID

Columns