View: QP_SHIP_TO_ORGS_V

Product:	QP - Advanced Pricing
Description:	Ship to Organizations.
Implementation/DBA Data:	APPS.QP_SHIP_TO_ORGS_V

View Text

SELECT /*+ FIRST_ROWS */ PARTY.PARTY_NAME
, S_SHIP.LOCATION
, LOC_SHIP.ADDRESS1
, LOC_SHIP.ADDRESS2
, LOC_SHIP.ADDRESS3
, S_SHIP.SITE_USE_ID
, ORG.ORGANIZATION_ID
, ORG.NAME
FROM HZ_PARTIES PARTY
, HZ_CUST_ACCOUNTS CUST_ACCT
, HZ_CUST_ACCT_SITES_ALL ACCT_SITE_SHIP
, HZ_PARTY_SITES PARTY_SITE_SHIP
, HZ_LOCATIONS LOC_SHIP
, HZ_CUST_SITE_USES_ALL S_SHIP
, HR_ORGANIZATION_UNITS ORG
WHERE ACCT_SITE_SHIP.CUST_ACCOUNT_ID = CUST_ACCT.CUST_ACCOUNT_ID
AND CUST_ACCT.STATUS = 'A'
AND ACCT_SITE_SHIP.STATUS = 'A'
AND CUST_ACCT.PARTY_ID = PARTY.PARTY_ID
AND ACCT_SITE_SHIP.PARTY_SITE_ID = PARTY_SITE_SHIP.PARTY_SITE_ID
AND PARTY_SITE_SHIP.LOCATION_ID = LOC_SHIP.LOCATION_ID
AND S_SHIP.CUST_ACCT_SITE_ID = ACCT_SITE_SHIP.CUST_ACCT_SITE_ID
AND S_SHIP.ORG_ID = ORG.ORGANIZATION_ID
AND S_SHIP.SITE_USE_CODE = 'SHIP_TO'

Columns