View: HZ_SITE_USES_V

Product:	AR - Receivables
Description:
Implementation/DBA Data:	APPS.HZ_SITE_USES_V

View Text

SELECT DISTINCT SU.ROWID
, SU.SITE_USE_ID
, SU.LAST_UPDATE_DATE
, SU.OBJECT_VERSION_NUMBER
, SU.LAST_UPDATED_BY
, SU.CREATION_DATE
, SU.CREATED_BY
, SU.SITE_USE_CODE
, SU.CUST_ACCT_SITE_ID ADDRESS_ID
, SU.PRIMARY_FLAG
, SU.STATUS
, SU.LOCATION
, SU.LAST_UPDATE_LOGIN
, SU.CONTACT_ID
, DECODE(ACCT_ROLE.CUST_ACCOUNT_ROLE_ID
, NULL
, NULL
, SUBSTRB(PARTY.PERSON_LAST_NAME
, 1
, 50) || '
, ' || SUBSTRB(PARTY.PERSON_FIRST_NAME
, 1
, 40)) CONTACT_NAME
, SU.BILL_TO_SITE_USE_ID
, SU_BILL.LOCATION
, SU.ORIG_SYSTEM_REFERENCE
, SU.SIC_CODE
, SU.PAYMENT_TERM_ID
, TERM.NAME
, SU.GSA_INDICATOR
, SU.SHIP_PARTIAL
, SU.SHIP_VIA
, SU.FOB_POINT
, SU.ORDER_TYPE_ID
, ORDT.NAME
, SU.PRICE_LIST_ID
, LIST.NAME
, SU.FREIGHT_TERM
, SU.WAREHOUSE_ID
, ORG.NAME
, SU.TERRITORY_ID
, SU.ATTRIBUTE_CATEGORY
, SU.ATTRIBUTE1
, SU.ATTRIBUTE2
, SU.ATTRIBUTE3
, SU.ATTRIBUTE4
, SU.ATTRIBUTE5
, SU.ATTRIBUTE6
, SU.ATTRIBUTE7
, SU.ATTRIBUTE8
, SU.ATTRIBUTE9
, SU.ATTRIBUTE10
, SU.ATTRIBUTE11
, SU.ATTRIBUTE12
, SU.ATTRIBUTE13
, SU.ATTRIBUTE14
, SU.ATTRIBUTE15
, SU.ATTRIBUTE16
, SU.ATTRIBUTE17
, SU.ATTRIBUTE18
, SU.ATTRIBUTE19
, SU.ATTRIBUTE20
, SU.ATTRIBUTE21
, SU.ATTRIBUTE22
, SU.ATTRIBUTE23
, SU.ATTRIBUTE24
, SU.ATTRIBUTE25
, SU.TAX_REFERENCE
, SU.TAX_CODE
, SU.DEMAND_CLASS_CODE
, HRL.LOCATION_ID
, HRL.LOCATION_CODE
, INV_ORG.ORGANIZATION_ID
, INV_ORG.NAME
, SU.TAX_CLASSIFICATION
, SU.TAX_HEADER_LEVEL_FLAG
, SU.TAX_ROUNDING_RULE
, SU.GLOBAL_ATTRIBUTE_CATEGORY
, SU.GLOBAL_ATTRIBUTE1
, SU.GLOBAL_ATTRIBUTE2
, SU.GLOBAL_ATTRIBUTE3
, SU.GLOBAL_ATTRIBUTE4
, SU.GLOBAL_ATTRIBUTE5
, SU.GLOBAL_ATTRIBUTE6
, SU.GLOBAL_ATTRIBUTE7
, SU.GLOBAL_ATTRIBUTE8
, SU.GLOBAL_ATTRIBUTE9
, SU.GLOBAL_ATTRIBUTE10
, SU.GLOBAL_ATTRIBUTE11
, SU.GLOBAL_ATTRIBUTE12
, SU.GLOBAL_ATTRIBUTE13
, SU.GLOBAL_ATTRIBUTE14
, SU.GLOBAL_ATTRIBUTE15
, SU.GLOBAL_ATTRIBUTE16
, SU.GLOBAL_ATTRIBUTE17
, SU.GLOBAL_ATTRIBUTE18
, SU.GLOBAL_ATTRIBUTE19
, SU.GLOBAL_ATTRIBUTE20
, SU.PRIMARY_SALESREP_ID
, RES.RESOURCE_NAME
, SU.FINCHRG_RECEIVABLES_TRX_ID
, RT.NAME
, SU.GL_ID_REV
, SU.GL_ID_FREIGHT
, SU.GL_ID_REC
, SU.GL_ID_CLEARING
, SU.GL_ID_TAX
, SU.GL_ID_UNBILLED
, SU.GL_ID_UNEARNED
, SU.GL_ID_UNPAID_REC
, SU.GL_ID_REMITTANCE
, SU.GL_ID_FACTOR
, SU.DATES_NEGATIVE_TOLERANCE
, SU.DATES_POSITIVE_TOLERANCE
, SU.DATE_TYPE_PREFERENCE
, SU.OVER_SHIPMENT_TOLERANCE
, SU.UNDER_SHIPMENT_TOLERANCE
, SU.ITEM_CROSS_REF_PREF
, SU.OVER_RETURN_TOLERANCE
, SU.UNDER_RETURN_TOLERANCE
, SU.SHIP_SETS_INCLUDE_LINES_FLAG
, SU.ARRIVALSETS_INCLUDE_LINES_FLAG
, SU.SCHED_DATE_PUSH_FLAG
, SU.INVOICE_QUANTITY_RULE
, SU.PRICING_EVENT
, SU.ORG_ID
FROM HZ_CUST_SITE_USES SU
, HZ_CUST_SITE_USES SU_BILL
, RA_TERMS TERM
, HZ_CUST_ACCOUNT_ROLES ACCT_ROLE
, HZ_PARTIES PARTY
, HZ_RELATIONSHIPS REL
, HR_ALL_ORGANIZATION_UNITS ORG
, SO_ORDER_TYPES ORDT
, SO_PRICE_LISTS LIST
, PO_LOCATION_ASSOCIATIONS PLA
, HR_LOCATIONS HRL
, JTF_RS_SALESREPS SR
, HR_ORGANIZATION_UNITS INV_ORG
, AR_RECEIVABLES_TRX RT
, JTF_RS_RESOURCE_EXTNS_VL RES
WHERE SU.BILL_TO_SITE_USE_ID = SU_BILL.SITE_USE_ID(+)
AND SU.PAYMENT_TERM_ID = TERM.TERM_ID(+)
AND SU.CONTACT_ID = ACCT_ROLE.CUST_ACCOUNT_ROLE_ID(+)
AND ACCT_ROLE.PARTY_ID = REL.PARTY_ID(+)
AND REL.SUBJECT_TABLE_NAME(+) = 'HZ_PARTIES'
AND REL.OBJECT_TABLE_NAME(+) = 'HZ_PARTIES'
AND REL.DIRECTIONAL_FLAG(+) = 'F'
AND ACCT_ROLE.ROLE_TYPE(+) = 'CONTACT'
AND REL.SUBJECT_ID = PARTY.PARTY_ID(+)
AND SU.WAREHOUSE_ID = ORG.ORGANIZATION_ID(+)
AND SU.ORDER_TYPE_ID = ORDT.ORDER_TYPE_ID(+)
AND SU.PRICE_LIST_ID = LIST.PRICE_LIST_ID(+)
AND SU.SITE_USE_ID = PLA.SITE_USE_ID(+)
AND PLA.LOCATION_ID = HRL.LOCATION_ID(+)
AND PLA.ORGANIZATION_ID = INV_ORG.ORGANIZATION_ID(+)
AND SU.PRIMARY_SALESREP_ID = SR.SALESREP_ID (+)
AND SR.RESOURCE_ID = RES.RESOURCE_ID (+)
AND SU.FINCHRG_RECEIVABLES_TRX_ID = RT.RECEIVABLES_TRX_ID(+)

Columns