VIEW: APPS.AHL_VENDOR_CUSTOMER_RELS_V

Source

View Text - Preformatted

SELECT ahl.VENDOR_CUSTOMER_REL_ID, ahl.OBJECT_VERSION_NUMBER, ahl.CREATION_DATE, ahl.CREATED_BY, ahl.LAST_UPDATE_DATE, ahl.LAST_UPDATED_BY, ahl.LAST_UPDATE_LOGIN, ven.VENDOR_ID, ven.VENDOR_NAME, site.VENDOR_SITE_ID, site.VENDOR_SITE_CODE vendor_location, cust.cust_account_id customer_id, cust.account_number customer_number, party.party_name customer_name, ship.organization_id customer_site_id, ship.name customer_location, ahl.ATTRIBUTE_CATEGORY, ahl.ATTRIBUTE1, ahl.ATTRIBUTE2, ahl.ATTRIBUTE3, ahl.ATTRIBUTE4, ahl.ATTRIBUTE5, ahl.ATTRIBUTE6, ahl.ATTRIBUTE7, ahl.ATTRIBUTE8, ahl.ATTRIBUTE9, ahl.ATTRIBUTE10, ahl.ATTRIBUTE11, ahl.ATTRIBUTE12, ahl.ATTRIBUTE13, ahl.ATTRIBUTE14, ahl.ATTRIBUTE15 FROM AHL_VENDOR_CUSTOMER_RELS ahl, PO_VENDORS ven, PO_VENDOR_SITES site, HZ_PARTIES party, HZ_CUST_ACCOUNTS cust, OE_SHIP_TO_ORGS_V ship WHERE ahl.vendor_site_id = site.vendor_site_id AND ahl.customer_site_id = ship.organization_id AND site.vendor_id = ven.vendor_id AND ship.customer_id = cust.cust_account_id AND cust.party_id = party.party_id

View Text - HTML Formatted

SELECT AHL.VENDOR_CUSTOMER_REL_ID
, AHL.OBJECT_VERSION_NUMBER
, AHL.CREATION_DATE
, AHL.CREATED_BY
, AHL.LAST_UPDATE_DATE
, AHL.LAST_UPDATED_BY
, AHL.LAST_UPDATE_LOGIN
, VEN.VENDOR_ID
, VEN.VENDOR_NAME
, SITE.VENDOR_SITE_ID
, SITE.VENDOR_SITE_CODE VENDOR_LOCATION
, CUST.CUST_ACCOUNT_ID CUSTOMER_ID
, CUST.ACCOUNT_NUMBER CUSTOMER_NUMBER
, PARTY.PARTY_NAME CUSTOMER_NAME
, SHIP.ORGANIZATION_ID CUSTOMER_SITE_ID
, SHIP.NAME CUSTOMER_LOCATION
, AHL.ATTRIBUTE_CATEGORY
, AHL.ATTRIBUTE1
, AHL.ATTRIBUTE2
, AHL.ATTRIBUTE3
, AHL.ATTRIBUTE4
, AHL.ATTRIBUTE5
, AHL.ATTRIBUTE6
, AHL.ATTRIBUTE7
, AHL.ATTRIBUTE8
, AHL.ATTRIBUTE9
, AHL.ATTRIBUTE10
, AHL.ATTRIBUTE11
, AHL.ATTRIBUTE12
, AHL.ATTRIBUTE13
, AHL.ATTRIBUTE14
, AHL.ATTRIBUTE15
FROM AHL_VENDOR_CUSTOMER_RELS AHL
, PO_VENDORS VEN
, PO_VENDOR_SITES SITE
, HZ_PARTIES PARTY
, HZ_CUST_ACCOUNTS CUST
, OE_SHIP_TO_ORGS_V SHIP
WHERE AHL.VENDOR_SITE_ID = SITE.VENDOR_SITE_ID
AND AHL.CUSTOMER_SITE_ID = SHIP.ORGANIZATION_ID
AND SITE.VENDOR_ID = VEN.VENDOR_ID
AND SHIP.CUSTOMER_ID = CUST.CUST_ACCOUNT_ID
AND CUST.PARTY_ID = PARTY.PARTY_ID