VIEW: APPS.ASO_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_SHIP_PARTIES.PARTY_NAME SHIP_TO_PARTY_NAME, I_SHIP_PARTIES.PERSON_FIRST_NAME SHIP_TO_CONTACT_FIRST_NAME, I_SHIP_PARTIES.PERSON_MIDDLE_NAME SHIP_TO_CONTACT_MIDDLE_NAME, I_SHIP_PARTIES.PERSON_LAST_NAME SHIP_TO_CONTACT_LAST_NAME, 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_CODE SHIP_TO_COUNTRY_CODE, I_SHIP_ADDR.COUNTRY 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_TO_CUST_ACCOUNT_ID, I_SHIP_CUST_PARTIES.PARTY_NAME, SHIP.SHIP_FROM_ORG_ID, SHIP.SHIP_TO_CUST_PARTY_ID FROM ASO_SHIPMENTS SHIP, ASO_I_PARTY_SITES_V I_SHIP_ADDR, ASO_I_PARTIES_V I_SHIP_PARTIES, ASO_I_COUNTRIES_V I_COUNTRY, ASO_I_PARTIES_V I_SHIP_CUST_PARTIES WHERE SHIP.SHIP_TO_PARTY_SITE_ID = I_SHIP_ADDR.PARTY_SITE_ID(+) AND SHIP.SHIP_TO_PARTY_ID = I_SHIP_PARTIES.PARTY_ID(+) AND I_SHIP_ADDR.COUNTRY_CODE = I_COUNTRY.TERRITORY_SHORT_NAME(+) AND SHIP.SHIP_TO_CUST_PARTY_ID = I_SHIP_CUST_PARTIES.PARTY_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_SHIP_PARTIES.PARTY_NAME SHIP_TO_PARTY_NAME
, I_SHIP_PARTIES.PERSON_FIRST_NAME SHIP_TO_CONTACT_FIRST_NAME
, I_SHIP_PARTIES.PERSON_MIDDLE_NAME SHIP_TO_CONTACT_MIDDLE_NAME
, I_SHIP_PARTIES.PERSON_LAST_NAME SHIP_TO_CONTACT_LAST_NAME
, 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_CODE SHIP_TO_COUNTRY_CODE
, I_SHIP_ADDR.COUNTRY 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_TO_CUST_ACCOUNT_ID
, I_SHIP_CUST_PARTIES.PARTY_NAME
, SHIP.SHIP_FROM_ORG_ID
, SHIP.SHIP_TO_CUST_PARTY_ID
FROM ASO_SHIPMENTS SHIP
, ASO_I_PARTY_SITES_V I_SHIP_ADDR
, ASO_I_PARTIES_V I_SHIP_PARTIES
, ASO_I_COUNTRIES_V I_COUNTRY
, ASO_I_PARTIES_V I_SHIP_CUST_PARTIES
WHERE SHIP.SHIP_TO_PARTY_SITE_ID = I_SHIP_ADDR.PARTY_SITE_ID(+)
AND SHIP.SHIP_TO_PARTY_ID = I_SHIP_PARTIES.PARTY_ID(+)
AND I_SHIP_ADDR.COUNTRY_CODE = I_COUNTRY.TERRITORY_SHORT_NAME(+)
AND SHIP.SHIP_TO_CUST_PARTY_ID = I_SHIP_CUST_PARTIES.PARTY_ID(+)