VIEW: APPS.ASO_PVT_SHIPMENTS_V

Source

View Text - Preformatted

SELECT SHIP.SHIPMENT_ID, SHIP.CREATION_DATE, SHIP.CREATED_BY, SHIP.LAST_UPDATE_DATE, SHIP.LAST_UPDATED_BY, SHIP.LAST_UPDATE_LOGIN, SHIP.REQUEST_ID, SHIP.PROGRAM_APPLICATION_ID, SHIP.PROGRAM_ID, SHIP.PROGRAM_UPDATE_DATE, SHIP.QUOTE_HEADER_ID, SHIP.QUOTE_LINE_ID, SHIP.PROMISE_DATE, SHIP.REQUEST_DATE, SHIP.SCHEDULE_SHIP_DATE, SHIP.SHIP_TO_PARTY_ID, I_PARTY_REL.PARTY_ID, I_PARTY_REL_PARTY.PARTY_NAME, NULL, NULL, NULL, SHIP.SHIP_TO_PARTY_SITE_ID, I_SHIP_ADDR.ADDRESS1 SHIP_TO_ADDRESS1, I_SHIP_ADDR.ADDRESS2 SHIP_TO_ADDRESS2, I_SHIP_ADDR.ADDRESS3 SHIP_TO_ADDRESS3, I_SHIP_ADDR.ADDRESS4 SHIP_TO_ADDRESS4, I_SHIP_ADDR.COUNTRY SHIP_TO_COUNTRY_CODE, FND_TERRITORIES_VL.territory_short_name SHIP_TO_COUNTRY, I_SHIP_ADDR.CITY SHIP_TO_CITY, I_SHIP_ADDR.POSTAL_CODE SHIP_TO_POSTAL_CODE, I_SHIP_ADDR.STATE SHIP_TO_STATE, I_SHIP_ADDR.PROVINCE SHIP_TO_PROVINCE, I_SHIP_ADDR.COUNTY SHIP_TO_COUNTY, SHIP.SHIP_PARTIAL_FLAG, SHIP.SHIP_SET_ID, SHIP.SHIP_METHOD_CODE, SHIP.FREIGHT_TERMS_CODE, SHIP.FREIGHT_CARRIER_CODE, SHIP.FOB_CODE, SHIP.SHIPPING_INSTRUCTIONS, SHIP.PACKING_INSTRUCTIONS, SHIP.QUANTITY, SHIP.RESERVED_QUANTITY, SHIP.RESERVATION_ID, SHIP.ORDER_LINE_ID, SHIP.SHIPMENT_PRIORITY_CODE, SHIP.ATTRIBUTE_CATEGORY, SHIP.ATTRIBUTE1, SHIP.ATTRIBUTE2, SHIP.ATTRIBUTE3, SHIP.ATTRIBUTE4, SHIP.ATTRIBUTE5, SHIP.ATTRIBUTE6, SHIP.ATTRIBUTE7, SHIP.ATTRIBUTE8, SHIP.ATTRIBUTE9, SHIP.ATTRIBUTE10, SHIP.ATTRIBUTE11, SHIP.ATTRIBUTE12, SHIP.ATTRIBUTE13, SHIP.ATTRIBUTE14, SHIP.ATTRIBUTE15, SHIP.SHIP_QUOTE_PRICE, SHIP.SHIP_TO_CUST_ACCOUNT_ID, SHIP.SHIP_TO_CUST_PARTY_ID, I_CUST_PARTIES.PARTY_NAME CUSTOMER_NAME, I_CUST_PARTIES.PARTY_TYPE CUSTOMER_TYPE, I_CUST.ACCOUNT_NUMBER CUSTOMER_ACCOUNT_NUMBER FROM ASO_SHIPMENTS SHIP, hz_party_sites I_SHIP_SITE, hz_locations I_SHIP_ADDR, hz_relationships I_PARTY_REL, hz_parties I_PARTY_REL_PARTY, hz_cust_accounts I_CUST, hz_parties I_CUST_PARTIES, FND_TERRITORIES_VL WHERE SHIP.SHIP_TO_PARTY_SITE_ID = I_SHIP_SITE.PARTY_SITE_ID(+) and I_SHIP_SITE.location_id = I_SHIP_ADDR.location_id(+) and I_SHIP_ADDR.country = FND_TERRITORIES_VL.territory_code(+) AND SHIP.SHIP_TO_PARTY_ID = I_PARTY_REL.PARTY_ID(+) and I_PARTY_REL.SUBJECT_ID = I_PARTY_REL_PARTY.PARTY_ID(+) AND I_PARTY_REL.SUBJECT_TYPE(+) = 'PERSON' AND I_PARTY_REL.SUBJECT_TABLE_NAME(+) = 'HZ_PARTIES' AND I_PARTY_REL.OBJECT_ID(+) = SHIP.SHIP_TO_CUST_PARTY_ID AND SHIP.SHIP_TO_CUST_PARTY_ID = I_CUST_PARTIES.PARTY_ID(+) AND SHIP.SHIP_TO_CUST_ACCOUNT_ID = I_CUST.CUST_ACCOUNT_ID(+)

View Text - HTML Formatted

SELECT SHIP.SHIPMENT_ID
, SHIP.CREATION_DATE
, SHIP.CREATED_BY
, SHIP.LAST_UPDATE_DATE
, SHIP.LAST_UPDATED_BY
, SHIP.LAST_UPDATE_LOGIN
, SHIP.REQUEST_ID
, SHIP.PROGRAM_APPLICATION_ID
, SHIP.PROGRAM_ID
, SHIP.PROGRAM_UPDATE_DATE
, SHIP.QUOTE_HEADER_ID
, SHIP.QUOTE_LINE_ID
, SHIP.PROMISE_DATE
, SHIP.REQUEST_DATE
, SHIP.SCHEDULE_SHIP_DATE
, SHIP.SHIP_TO_PARTY_ID
, I_PARTY_REL.PARTY_ID
, I_PARTY_REL_PARTY.PARTY_NAME
, NULL
, NULL
, NULL
, SHIP.SHIP_TO_PARTY_SITE_ID
, I_SHIP_ADDR.ADDRESS1 SHIP_TO_ADDRESS1
, I_SHIP_ADDR.ADDRESS2 SHIP_TO_ADDRESS2
, I_SHIP_ADDR.ADDRESS3 SHIP_TO_ADDRESS3
, I_SHIP_ADDR.ADDRESS4 SHIP_TO_ADDRESS4
, I_SHIP_ADDR.COUNTRY SHIP_TO_COUNTRY_CODE
, FND_TERRITORIES_VL.TERRITORY_SHORT_NAME SHIP_TO_COUNTRY
, I_SHIP_ADDR.CITY SHIP_TO_CITY
, I_SHIP_ADDR.POSTAL_CODE SHIP_TO_POSTAL_CODE
, I_SHIP_ADDR.STATE SHIP_TO_STATE
, I_SHIP_ADDR.PROVINCE SHIP_TO_PROVINCE
, I_SHIP_ADDR.COUNTY SHIP_TO_COUNTY
, SHIP.SHIP_PARTIAL_FLAG
, SHIP.SHIP_SET_ID
, SHIP.SHIP_METHOD_CODE
, SHIP.FREIGHT_TERMS_CODE
, SHIP.FREIGHT_CARRIER_CODE
, SHIP.FOB_CODE
, SHIP.SHIPPING_INSTRUCTIONS
, SHIP.PACKING_INSTRUCTIONS
, SHIP.QUANTITY
, SHIP.RESERVED_QUANTITY
, SHIP.RESERVATION_ID
, SHIP.ORDER_LINE_ID
, SHIP.SHIPMENT_PRIORITY_CODE
, SHIP.ATTRIBUTE_CATEGORY
, SHIP.ATTRIBUTE1
, SHIP.ATTRIBUTE2
, SHIP.ATTRIBUTE3
, SHIP.ATTRIBUTE4
, SHIP.ATTRIBUTE5
, SHIP.ATTRIBUTE6
, SHIP.ATTRIBUTE7
, SHIP.ATTRIBUTE8
, SHIP.ATTRIBUTE9
, SHIP.ATTRIBUTE10
, SHIP.ATTRIBUTE11
, SHIP.ATTRIBUTE12
, SHIP.ATTRIBUTE13
, SHIP.ATTRIBUTE14
, SHIP.ATTRIBUTE15
, SHIP.SHIP_QUOTE_PRICE
, SHIP.SHIP_TO_CUST_ACCOUNT_ID
, SHIP.SHIP_TO_CUST_PARTY_ID
, I_CUST_PARTIES.PARTY_NAME CUSTOMER_NAME
, I_CUST_PARTIES.PARTY_TYPE CUSTOMER_TYPE
, I_CUST.ACCOUNT_NUMBER CUSTOMER_ACCOUNT_NUMBER
FROM ASO_SHIPMENTS SHIP
, HZ_PARTY_SITES I_SHIP_SITE
, HZ_LOCATIONS I_SHIP_ADDR
, HZ_RELATIONSHIPS I_PARTY_REL
, HZ_PARTIES I_PARTY_REL_PARTY
, HZ_CUST_ACCOUNTS I_CUST
, HZ_PARTIES I_CUST_PARTIES
, FND_TERRITORIES_VL
WHERE SHIP.SHIP_TO_PARTY_SITE_ID = I_SHIP_SITE.PARTY_SITE_ID(+)
AND I_SHIP_SITE.LOCATION_ID = I_SHIP_ADDR.LOCATION_ID(+)
AND I_SHIP_ADDR.COUNTRY = FND_TERRITORIES_VL.TERRITORY_CODE(+)
AND SHIP.SHIP_TO_PARTY_ID = I_PARTY_REL.PARTY_ID(+)
AND I_PARTY_REL.SUBJECT_ID = I_PARTY_REL_PARTY.PARTY_ID(+)
AND I_PARTY_REL.SUBJECT_TYPE(+) = 'PERSON'
AND I_PARTY_REL.SUBJECT_TABLE_NAME(+) = 'HZ_PARTIES'
AND I_PARTY_REL.OBJECT_ID(+) = SHIP.SHIP_TO_CUST_PARTY_ID
AND SHIP.SHIP_TO_CUST_PARTY_ID = I_CUST_PARTIES.PARTY_ID(+)
AND SHIP.SHIP_TO_CUST_ACCOUNT_ID = I_CUST.CUST_ACCOUNT_ID(+)