VIEW: APPS.AR_SITE_USES_V

Source

View Text - Preformatted

SELECT 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 , L_SU.MEANING , 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 , L_FOB.MEANING , SU.ORDER_TYPE_ID , ORDT.NAME , SU.PRICE_LIST_ID , LIST.NAME , SU.FREIGHT_TERM , L_FT.MEANING , 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 , COMM.MEANING , 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 , SR.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 FROM HZ_CUST_SITE_USES SU, HZ_CUST_SITE_USES SU_BILL, AR_LOOKUPS L_SU, RA_TERMS TERM, AR_LOOKUPS L_FOB, HZ_CUST_ACCOUNT_ROLES ACCT_ROLE, HZ_PARTIES PARTY, HZ_RELATIONSHIPS REL, FND_COMMON_LOOKUPS COMM, SO_LOOKUPS L_FT, HR_ALL_ORGANIZATION_UNITS ORG, SO_ORDER_TYPES ORDT, SO_PRICE_LISTS LIST, PO_LOCATION_ASSOCIATIONS PLA, HR_LOCATIONS HRL, RA_SALESREPS SR, HR_ORGANIZATION_UNITS INV_ORG, AR_RECEIVABLES_TRX RT WHERE SU.BILL_TO_SITE_USE_ID = SU_BILL.SITE_USE_ID(+) AND SU.SITE_USE_CODE = L_SU.LOOKUP_CODE(+) AND L_SU.LOOKUP_TYPE(+) = 'SITE_USE_CODE' AND SU.PAYMENT_TERM_ID = TERM.TERM_ID(+) AND SU.FOB_POINT = L_FOB.LOOKUP_CODE(+) AND L_FOB.LOOKUP_TYPE(+) = 'FOB' 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.DEMAND_CLASS_CODE = COMM.LOOKUP_CODE(+) AND COMM.LOOKUP_TYPE(+) = 'DEMAND_CLASS' AND SU.FREIGHT_TERM = L_FT.LOOKUP_CODE(+) AND L_FT.LOOKUP_TYPE(+) = 'FREIGHT_TERMS' 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 SU.FINCHRG_RECEIVABLES_TRX_ID = RT.RECEIVABLES_TRX_ID(+)

View Text - HTML Formatted

SELECT 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
, L_SU.MEANING
, 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
, L_FOB.MEANING
, SU.ORDER_TYPE_ID
, ORDT.NAME
, SU.PRICE_LIST_ID
, LIST.NAME
, SU.FREIGHT_TERM
, L_FT.MEANING
, 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
, COMM.MEANING
, 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
, SR.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
FROM HZ_CUST_SITE_USES SU
, HZ_CUST_SITE_USES SU_BILL
, AR_LOOKUPS L_SU
, RA_TERMS TERM
, AR_LOOKUPS L_FOB
, HZ_CUST_ACCOUNT_ROLES ACCT_ROLE
, HZ_PARTIES PARTY
, HZ_RELATIONSHIPS REL
, FND_COMMON_LOOKUPS COMM
, SO_LOOKUPS L_FT
, HR_ALL_ORGANIZATION_UNITS ORG
, SO_ORDER_TYPES ORDT
, SO_PRICE_LISTS LIST
, PO_LOCATION_ASSOCIATIONS PLA
, HR_LOCATIONS HRL
, RA_SALESREPS SR
, HR_ORGANIZATION_UNITS INV_ORG
, AR_RECEIVABLES_TRX RT
WHERE SU.BILL_TO_SITE_USE_ID = SU_BILL.SITE_USE_ID(+)
AND SU.SITE_USE_CODE = L_SU.LOOKUP_CODE(+)
AND L_SU.LOOKUP_TYPE(+) = 'SITE_USE_CODE'
AND SU.PAYMENT_TERM_ID = TERM.TERM_ID(+)
AND SU.FOB_POINT = L_FOB.LOOKUP_CODE(+)
AND L_FOB.LOOKUP_TYPE(+) = 'FOB'
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.DEMAND_CLASS_CODE = COMM.LOOKUP_CODE(+)
AND COMM.LOOKUP_TYPE(+) = 'DEMAND_CLASS'
AND SU.FREIGHT_TERM = L_FT.LOOKUP_CODE(+)
AND L_FT.LOOKUP_TYPE(+) = 'FREIGHT_TERMS'
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 SU.FINCHRG_RECEIVABLES_TRX_ID = RT.RECEIVABLES_TRX_ID(+)