Product: | IBE - iStore |
---|---|
Description: | |
Implementation/DBA Data: | Not implemented in this database |
SELECT S.SHIPMENT_ID SHIPMENT_ID
, S.CREATION_DATE SHIP_CREATION_DATE
, S.CREATED_BY SHIP_CREATED_BY
, S.LAST_UPDATE_DATE SHIP_LAST_UPDATE_DATE
, S.LAST_UPDATED_BY SHIP_LAST_UPDATED_BY
, S.LAST_UPDATE_LOGIN SHIP_LAST_UPDATE_LOGIN
, S.REQUEST_ID SHIP_REQUEST_ID
, S.PROGRAM_APPLICATION_ID SHIP_PROGRAM_APPLICATION_ID
, S.PROGRAM_ID SHIP_PROGRAM_ID
, S.PROGRAM_UPDATE_DATE SHIP_PROGRAM_UPDATE_DATE
, S.QUOTE_HEADER_ID QUOTE_HEADER_ID
, S.QUOTE_LINE_ID QUOTE_LINE_ID
, S.PROMISE_DATE PROMISE_DATE
, S.REQUEST_DATE REQUEST_DATE
, S.SCHEDULE_SHIP_DATE SCHEDULE_SHIP_DATE
, S.SHIP_TO_PARTY_SITE_ID SHIP_TO_PARTY_SITE_ID
, S.SHIP_TO_PARTY_ID SHIP_TO_PARTY_ID
, S.SHIP_PARTIAL_FLAG SHIP_PARTIAL_FLAG
, S.SHIP_SET_ID SHIP_SET_ID
, S.SHIP_METHOD_CODE SHIP_METHOD_CODE
, S.FREIGHT_TERMS_CODE FREIGHT_TERMS_CODE
, S.FREIGHT_CARRIER_CODE FREIGHT_CARRIER_CODE
, S.FOB_CODE FOB_CODE
, S.SHIPPING_INSTRUCTIONS SHIPPING_INSTRUCTIONS
, S.PACKING_INSTRUCTIONS PACKING_INSTRUCTIONS
, S.QUANTITY QUANTITY
, S.RESERVED_QUANTITY RESERVED_QUANTITY
, S.RESERVATION_ID RESERVATION_ID
, S.ORDER_LINE_ID ORDER_LINE_ID
, S.ATTRIBUTE_CATEGORY SHIP_ATTRIBUTE_CATEGORY
, S.ATTRIBUTE1 SHIP_ATTRIBUTE1
, S.ATTRIBUTE2 SHIP_ATTRIBUTE2
, S.ATTRIBUTE3 SHIP_ATTRIBUTE3
, S.ATTRIBUTE4 SHIP_ATTRIBUTE4
, S.ATTRIBUTE5 SHIP_ATTRIBUTE5
, S.ATTRIBUTE6 SHIP_ATTRIBUTE6
, S.ATTRIBUTE7 SHIP_ATTRIBUTE7
, S.ATTRIBUTE8 SHIP_ATTRIBUTE8
, S.ATTRIBUTE9 SHIP_ATTRIBUTE9
, S.ATTRIBUTE10 SHIP_ATTRIBUTE10
, S.ATTRIBUTE11 SHIP_ATTRIBUTE11
, S.ATTRIBUTE12 SHIP_ATTRIBUTE12
, S.ATTRIBUTE13 SHIP_ATTRIBUTE13
, S.ATTRIBUTE14 SHIP_ATTRIBUTE14
, S.ATTRIBUTE15 SHIP_ATTRIBUTE15
, P.PARTY_NAME
, L.LOCATION_ID
, L.WH_UPDATE_DATE
, L.ATTRIBUTE_CATEGORY
, L.ATTRIBUTE1
, L.ATTRIBUTE2
, L.ATTRIBUTE3
, L.ATTRIBUTE4
, L.ATTRIBUTE5
, L.ATTRIBUTE6
, L.ATTRIBUTE7
, L.ATTRIBUTE8
, L.ATTRIBUTE9
, L.ATTRIBUTE10
, L.ATTRIBUTE11
, L.ATTRIBUTE12
, L.ATTRIBUTE13
, L.ATTRIBUTE14
, L.ATTRIBUTE15
, L.ATTRIBUTE16
, L.ATTRIBUTE17
, L.ATTRIBUTE18
, L.ATTRIBUTE19
, L.ATTRIBUTE20
, L.GLOBAL_ATTRIBUTE_CATEGORY
, L.GLOBAL_ATTRIBUTE1
, L.GLOBAL_ATTRIBUTE2
, L.GLOBAL_ATTRIBUTE3
, L.GLOBAL_ATTRIBUTE4
, L.GLOBAL_ATTRIBUTE5
, L.GLOBAL_ATTRIBUTE6
, L.GLOBAL_ATTRIBUTE7
, L.GLOBAL_ATTRIBUTE8
, L.GLOBAL_ATTRIBUTE9
, L.GLOBAL_ATTRIBUTE10
, L.GLOBAL_ATTRIBUTE11
, L.GLOBAL_ATTRIBUTE12
, L.GLOBAL_ATTRIBUTE13
, L.GLOBAL_ATTRIBUTE14
, L.GLOBAL_ATTRIBUTE15
, L.GLOBAL_ATTRIBUTE16
, L.GLOBAL_ATTRIBUTE17
, L.GLOBAL_ATTRIBUTE18
, L.GLOBAL_ATTRIBUTE19
, L.GLOBAL_ATTRIBUTE20
, L.ORIG_SYSTEM_REFERENCE
, L.COUNTRY
, L.ADDRESS1
, L.ADDRESS2
, L.ADDRESS3
, L.ADDRESS4
, L.CITY
, L.POSTAL_CODE
, L.STATE
, L.PROVINCE
, L.COUNTY
, L.ADDRESS_KEY
, L.ADDRESS_STYLE
, L.VALIDATED_FLAG
, L.ADDRESS_LINES_PHONETIC
, L.APARTMENT_FLAG
, L.PO_BOX_NUMBER
, L.HOUSE_NUMBER
, L.STREET_SUFFIX
, L.APARTMENT_NUMBER
, L.SECONDARY_SUFFIX_ELEMENT
, L.STREET
, L.RURAL_ROUTE_TYPE
, L.RURAL_ROUTE_NUMBER
, L.STREET_NUMBER
, L.BUILDING
, L.FLOOR
, L.SUITE
, L.ROOM
, L.POSTAL_PLUS4_CODE
, L.TIME_ZONE
, L.OVERSEAS_ADDRESS_FLAG
, L.POST_OFFICE
, L.POSITION
, L.DELIVERY_POINT_CODE
, L.LOCATION_DIRECTIONS
, NULL ADDRESS_EFFECTIVE_DATE
, NULL ADDRESS_EXPIRATION_DATE
, NULL ADDRESS_ERROR_CODE
, L.CLLI_CODE
, L.DODAAC
, L.TRAILING_DIRECTORY_CODE
, L.LANGUAGE
, L.LIFE_CYCLE_STATUS
, L.SHORT_DESCRIPTION
, L.DESCRIPTION
, L.CONTENT_SOURCE_TYPE
, L.LOC_HIERARCHY_ID
FROM ASO_SHIPMENTS S
, HZ_PARTY_SITES PS
, IBE_ADDRESSES_V L
, HZ_PARTIES P
WHERE S.SHIP_TO_PARTY_ID = P.PARTY_ID(+)
AND S.SHIP_TO_PARTY_ID = PS.PARTY_ID(+)
AND S.SHIP_TO_PARTY_SITE_ID = PS.PARTY_SITE_ID(+)
AND PS.LOCATION_ID = L.LOCATION_ID(+)