View: XNC_QUOTE_SHIPMENTS_V

View Text

SELECT ASH.SHIPMENT_ID
, AQL.ORG_ID
, AQL.ORGANIZATION_ID
, AQH.QUOTE_NUMBER
, AQL.LINE_NUMBER
, AQL.QUANTITY LINE_QUANTITY
, AQL.INVENTORY_ITEM_ID
, MSI.PADDED_CONCATENATED_SEGMENTS ITEM_NAME
, MSI.DESCRIPTION ITEM_DESCRIPTION
, MSI.SHIPPABLE_ITEM_FLAG
, ASH.QUANTITY SHIPMENT_QUANTITY
, ASH.CREATION_DATE
, ASH.CREATED_BY
, ASH.LAST_UPDATE_DATE
, ASH.LAST_UPDATED_BY
, ASH.LAST_UPDATE_LOGIN
, ASH.REQUEST_ID
, ASH.PROGRAM_APPLICATION_ID
, ASH.PROGRAM_ID
, ASH.PROGRAM_UPDATE_DATE
, ASH.QUOTE_HEADER_ID
, ASH.QUOTE_LINE_ID
, ASH.PROMISE_DATE
, ASH.REQUEST_DATE
, ASH.SCHEDULE_SHIP_DATE
, ASH.SHIP_TO_PARTY_ID
, ASH.SHIP_METHOD_CODE
, AIP.PARTY_NAME SHIP_TO_PARTY_NAME
, AIP.PERSON_FIRST_NAME||' '|| AIP.PERSON_MIDDLE_NAME||' '|| AIP.PERSON_LAST_NAME SHIP_TO_CONTACT_NAME
, ASH.SHIP_TO_PARTY_SITE_ID
, APADI.ADDRESS1 SHIP_TO_ADDRESS1
, APADI.ADDRESS2 ||' '|| APADI.ADDRESS3 ||' '|| APADI.ADDRESS4 SHIP_TO_ADDRESS2
, APADI.CITY||DECODE(APADI.COUNTY
, NULL
, NULL
, '
, ')|| APADI.COUNTY||DECODE(APADI.STATE
, NULL
, NULL
, '
, ')|| APADI.STATE||DECODE(APADI.PROVINCE
, NULL
, NULL
, '
, ')|| APADI.PROVINCE||DECODE(APADI.POSTAL_CODE
, NULL
, NULL
, '
, ')|| APADI.POSTAL_CODE SHIP_TO_ADDRESS3
, APADI.COUNTRY SHIP_TO_ADDRESS4
, ASH.SHIP_PARTIAL_FLAG
, ASH.SHIP_SET_ID
, ASH.FREIGHT_TERMS_CODE
, ASH.FREIGHT_CARRIER_CODE
, ASH.FOB_CODE
, ASH.SHIPPING_INSTRUCTIONS
, ASH.PACKING_INSTRUCTIONS
, ASH.QUANTITY
, ASH.RESERVED_QUANTITY
, ASH.RESERVATION_ID
, ASH.ORDER_LINE_ID
, ASH.SHIPMENT_PRIORITY_CODE
, ASH.ATTRIBUTE_CATEGORY
, ASH.ATTRIBUTE1
, ASH.ATTRIBUTE2
, ASH.ATTRIBUTE3
, ASH.ATTRIBUTE4
, ASH.ATTRIBUTE5
, ASH.ATTRIBUTE6
, ASH.ATTRIBUTE7
, ASH.ATTRIBUTE8
, ASH.ATTRIBUTE9
, ASH.ATTRIBUTE10
, ASH.ATTRIBUTE11
, ASH.ATTRIBUTE12
, ASH.ATTRIBUTE13
, ASH.ATTRIBUTE14
, ASH.ATTRIBUTE15
FROM ASO_I_PARTY_ADDRESSES_V APADI
, ASO_I_COUNTRIES_V AIC
, ASO_I_PARTIES_V AIP
, ASO_QUOTE_HEADERS_ALL_V AQH
, MTL_SYSTEM_ITEMS_VL MSI
, ASO_QUOTE_LINES_ALL_V AQL
, ASO_SHIPMENTS ASH
WHERE ASH.QUOTE_LINE_ID = AQL.QUOTE_LINE_ID
AND AQL.ORGANIZATION_ID = MSI.ORGANIZATION_ID
AND AQL.INVENTORY_ITEM_ID = MSI.INVENTORY_ITEM_ID
AND AQL.QUOTE_HEADER_ID = AQH.QUOTE_HEADER_ID
AND ASH.SHIP_TO_PARTY_SITE_ID = APADI.PARTY_SITE_ID(+)
AND ASH.SHIP_TO_PARTY_ID = AIP.PARTY_ID(+)
AND APADI.COUNTRY_CODE = AIC.TERRITORY_SHORT_NAME(+)

Columns