VIEW: APPS.AST_ORG_PARTIES_V

Source

View Text - Preformatted

SELECT party.rowid, party.party_id, party.party_number, substr(party.party_name,1,360), party.party_type, party.validated_flag, party.last_update_date, party.last_updated_by, party.last_update_login, party.created_by, party.creation_date, party.sic_code, party.tax_reference, party.jgzz_fiscal_code, party.duns_number, party.tax_name, party.sic_code_type, party.total_num_of_orders, party.total_ordered_amount, party.last_ordered_date, party.analysis_fy, party.fiscal_yearend_month, party.employees_total, party.curr_fy_potential_revenue, party.next_fy_potential_revenue, party.year_established, party.gsa_indicator_flag, party.mission_statement, party.organization_name_phonetic, party.category_code, PARTY.ATTRIBUTE_CATEGORY, PARTY.ATTRIBUTE1, PARTY.ATTRIBUTE2, PARTY.ATTRIBUTE3, PARTY.ATTRIBUTE4, PARTY.ATTRIBUTE5, PARTY.ATTRIBUTE6, PARTY.ATTRIBUTE7, PARTY.ATTRIBUTE8, PARTY.ATTRIBUTE9, PARTY.ATTRIBUTE10, PARTY.ATTRIBUTE11, PARTY.ATTRIBUTE12, PARTY.ATTRIBUTE13, PARTY.ATTRIBUTE14, PARTY.ATTRIBUTE15, PARTY.ATTRIBUTE16, PARTY.ATTRIBUTE17, PARTY.ATTRIBUTE18, PARTY.ATTRIBUTE19, PARTY.ATTRIBUTE20, PARTY.ATTRIBUTE21, PARTY.ATTRIBUTE22, PARTY.ATTRIBUTE23, PARTY.ATTRIBUTE24, PARTY.OBJECT_VERSION_NUMBER, PARTY.CREATED_BY_MODULE, PARTY.APPLICATION_ID from HZ_PARTIES party WHERE party_type = 'ORGANIZATION'

View Text - HTML Formatted

SELECT PARTY.ROWID
, PARTY.PARTY_ID
, PARTY.PARTY_NUMBER
, SUBSTR(PARTY.PARTY_NAME
, 1
, 360)
, PARTY.PARTY_TYPE
, PARTY.VALIDATED_FLAG
, PARTY.LAST_UPDATE_DATE
, PARTY.LAST_UPDATED_BY
, PARTY.LAST_UPDATE_LOGIN
, PARTY.CREATED_BY
, PARTY.CREATION_DATE
, PARTY.SIC_CODE
, PARTY.TAX_REFERENCE
, PARTY.JGZZ_FISCAL_CODE
, PARTY.DUNS_NUMBER
, PARTY.TAX_NAME
, PARTY.SIC_CODE_TYPE
, PARTY.TOTAL_NUM_OF_ORDERS
, PARTY.TOTAL_ORDERED_AMOUNT
, PARTY.LAST_ORDERED_DATE
, PARTY.ANALYSIS_FY
, PARTY.FISCAL_YEAREND_MONTH
, PARTY.EMPLOYEES_TOTAL
, PARTY.CURR_FY_POTENTIAL_REVENUE
, PARTY.NEXT_FY_POTENTIAL_REVENUE
, PARTY.YEAR_ESTABLISHED
, PARTY.GSA_INDICATOR_FLAG
, PARTY.MISSION_STATEMENT
, PARTY.ORGANIZATION_NAME_PHONETIC
, PARTY.CATEGORY_CODE
, PARTY.ATTRIBUTE_CATEGORY
, PARTY.ATTRIBUTE1
, PARTY.ATTRIBUTE2
, PARTY.ATTRIBUTE3
, PARTY.ATTRIBUTE4
, PARTY.ATTRIBUTE5
, PARTY.ATTRIBUTE6
, PARTY.ATTRIBUTE7
, PARTY.ATTRIBUTE8
, PARTY.ATTRIBUTE9
, PARTY.ATTRIBUTE10
, PARTY.ATTRIBUTE11
, PARTY.ATTRIBUTE12
, PARTY.ATTRIBUTE13
, PARTY.ATTRIBUTE14
, PARTY.ATTRIBUTE15
, PARTY.ATTRIBUTE16
, PARTY.ATTRIBUTE17
, PARTY.ATTRIBUTE18
, PARTY.ATTRIBUTE19
, PARTY.ATTRIBUTE20
, PARTY.ATTRIBUTE21
, PARTY.ATTRIBUTE22
, PARTY.ATTRIBUTE23
, PARTY.ATTRIBUTE24
, PARTY.OBJECT_VERSION_NUMBER
, PARTY.CREATED_BY_MODULE
, PARTY.APPLICATION_ID
FROM HZ_PARTIES PARTY
WHERE PARTY_TYPE = 'ORGANIZATION'