Product: | IBE - iStore |
---|---|
Description: | |
Implementation/DBA Data: | Not implemented in this database |
SELECT HDR.QUOTE_HEADER_ID QUOTE_HEADER_ID
, HDR.CREATION_DATE HCREATION_DATE
, HDR.CREATED_BY HCREATED_BY
, HDR.LAST_UPDATE_DATE HLAST_UPDATE_DATE
, HDR.LAST_UPDATED_BY HLAST_UPDATED_BY
, HDR.LAST_UPDATE_LOGIN HLAST_UPDATE_LOGIN
, HDR.REQUEST_ID HREQUEST_ID
, HDR.PROGRAM_APPLICATION_ID HPROGRAM_APPLICATION_ID
, HDR.PROGRAM_ID HPROGRAM_ID
, HDR.PROGRAM_UPDATE_DATE HPROGRAM_UPDATE_DATE
, HDR.ORG_ID ORG_ID
, HDR.QUOTE_NAME QUOTE_NAME
, HDR.QUOTE_NUMBER QUOTE_NUMBER
, HDR.QUOTE_VERSION QUOTE_VERSION
, HDR.QUOTE_STATUS_ID QUOTE_STATUS_ID
, HDR.QUOTE_SOURCE_CODE QUOTE_SOURCE_CODE
, HDR.QUOTE_EXPIRATION_DATE QUOTE_EXPIRATION_DATE
, HDR.PRICE_FROZEN_DATE PRICE_FROZEN_DATE
, HDR.QUOTE_PASSWORD QUOTE_PASSWORD
, HDR.ORIGINAL_SYSTEM_REFERENCE ORIGINAL_SYSTEM_REFERENCE
, HDR.PARTY_ID PARTY_ID
, HDR.CUST_ACCOUNT_ID CUST_ACCOUNT_ID
, HDR.ORG_CONTACT_ID ORG_CONTACT_ID
, HDR.PHONE_ID PHONE_ID
, HDR.INVOICE_TO_PARTY_SITE_ID INVOICE_TO_PARTY_SITE_ID
, HDR.INVOICE_TO_PARTY_ID INVOICE_TO_PARTY_ID
, HDR.ORIG_MKTG_SOURCE_CODE_ID ORIG_MKTG_SOURCE_CODE_ID
, HDR.MARKETING_SOURCE_CODE_ID MARKETING_SOURCE_CODE_ID
, HDR.ORDER_TYPE_ID ORDER_TYPE_ID
, HDR.QUOTE_CATEGORY_CODE QUOTE_CATEGORY_CODE
, HDR.ORDERED_DATE ORDERED_DATE
, HDR.ACCOUNTING_RULE_ID ACCOUNTING_RULE_ID
, HDR.INVOICING_RULE_ID INVOICING_RULE_ID
, HDR.EMPLOYEE_PERSON_ID EMPLOYEE_PERSON_ID
, HDR.PRICE_LIST_ID PRICE_LIST_ID
, HDR.CURRENCY_CODE CURRENCY_CODE
, HDR.TOTAL_LIST_PRICE TOTAL_LIST_PRICE
, HDR.TOTAL_ADJUSTED_AMOUNT TOTAL_ADJUSTED_AMOUNT
, HDR.TOTAL_ADJUSTED_PERCENT TOTAL_ADJUSTED_PERCENT
, HDR.TOTAL_TAX TOTAL_TAX
, HDR.TOTAL_SHIPPING_CHARGE TOTAL_SHIPPING_CHARGE
, HDR.SURCHARGE SURCHARGE
, HDR.TOTAL_QUOTE_PRICE TOTAL_QUOTE_PRICE
, HDR.PAYMENT_AMOUNT PAYMENT_AMOUNT
, HDR.EXCHANGE_RATE EXCHANGE_RATE
, HDR.EXCHANGE_TYPE_CODE EXCHANGE_TYPE_CODE
, HDR.EXCHANGE_RATE_DATE EXCHANGE_RATE_DATE
, HDR.CONTRACT_ID CONTRACT_ID
, HDR.SALES_CHANNEL_CODE SALES_CHANNEL_CODE
, HDR.ORDER_ID ORDER_ID
, HDR.ATTRIBUTE_CATEGORY HATTRIBUTE_CATEGORY
, HDR.ATTRIBUTE1 HATTRIBUTE1
, HDR.ATTRIBUTE2 HATTRIBUTE2
, HDR.ATTRIBUTE3 HATTRIBUTE3
, HDR.ATTRIBUTE4 HATTRIBUTE4
, HDR.ATTRIBUTE5 HATTRIBUTE5
, HDR.ATTRIBUTE6 HATTRIBUTE6
, HDR.ATTRIBUTE7 HATTRIBUTE7
, HDR.ATTRIBUTE8 HATTRIBUTE8
, HDR.ATTRIBUTE9 HATTRIBUTE9
, HDR.ATTRIBUTE10 HATTRIBUTE10
, HDR.ATTRIBUTE11 HATTRIBUTE11
, HDR.ATTRIBUTE12 HATTRIBUTE12
, HDR.ATTRIBUTE13 HATTRIBUTE13
, HDR.ATTRIBUTE14 HATTRIBUTE14
, HDR.ATTRIBUTE15 HATTRIBUTE15
, P.PARTY_NAME LOCPARTY_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_QUOTE_HEADERS HDR
, HZ_PARTY_SITES PS
, HZ_PARTIES P
, IBE_ADDRESSES_V L
WHERE HDR.INVOICE_TO_PARTY_ID = P.PARTY_ID(+) AND HDR.INVOICE_TO_PARTY_SITE_ID = PS.PARTY_SITE_ID(+) AND HDR.INVOICE_TO_PARTY_ID = PS.PARTY_ID(+) AND PS.LOCATION_ID = L.LOCATION_ID(+)