eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: APPS.GMS_AWARDS_V

Source

View Text - Preformatted


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,360) 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,360) 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.INVOICE_LIMIT_FLAG, 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

View Text - HTML Formatted

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
, 360) 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
, 360) 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.INVOICE_LIMIT_FLAG
, 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