VIEW: APPS.QP_SHIP_TO_ORGS_V

Source

View Text - Preformatted

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 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'

View Text - HTML Formatted

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 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'