Product: | ASO - Order Capture |
---|---|
Description: | |
Implementation/DBA Data: | APPS.ASO_SHIPMENTS_V |
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_CUST.CUSTOMER_NAME
, SHIP.SHIP_FROM_ORG_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_CUST_ACCOUNTS_V I_CUST
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_ACCOUNT_ID = I_CUST.CUST_ACCOUNT_ID(+)