View: ASO_PVT_QUOTE_LINES_V

Product:	ASO - Order Capture
Description:
Implementation/DBA Data:	APPS.ASO_PVT_QUOTE_LINES_V

View Text

SELECT QUOTE_LINES.ROWID ROW_ID
, QUOTE_LINES.QUOTE_LINE_ID QUOTE_LINE_ID
, QUOTE_LINES.QUOTE_HEADER_ID QUOTE_HEADER_ID
, QUOTE_LINES.CREATION_DATE CREATION_DATE
, QUOTE_LINES.CREATED_BY CREATED_BY
, QUOTE_LINES.LAST_UPDATE_DATE LAST_UPDATE_DATE
, QUOTE_LINES.LAST_UPDATED_BY LAST_UPDATED_BY
, QUOTE_LINES.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, QUOTE_LINES.REQUEST_ID REQUEST_ID
, QUOTE_LINES.PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, QUOTE_LINES.PROGRAM_ID PROGRAM_ID
, QUOTE_LINES.PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, QUOTE_LINES.ORG_ID ORG_ID
, QUOTE_LINES.LINE_CATEGORY_CODE LINE_CATEGORY_CODE
, QUOTE_LINES.ITEM_TYPE_CODE ITEM_TYPE_CODE
, LOOKUP.MEANING ITEM_TYPE
, QUOTE_LINES.LINE_NUMBER LINE_NUMBER
, QUOTE_LINES.START_DATE_ACTIVE START_DATE_ACTIVE
, QUOTE_LINES.END_DATE_ACTIVE END_DATE_ACTIVE
, QUOTE_LINES.ORDER_LINE_TYPE_ID ORDER_LINE_TYPE_ID
, QUOTE_LINES.ORGANIZATION_ID ORGANIZATION_ID
, QUOTE_LINES.INVENTORY_ITEM_ID INVENTORY_ITEM_ID
, QUOTE_LINES.QUANTITY QUANTITY
, QUOTE_LINES.UOM_CODE UOM_CODE
, QUOTE_LINES.MARKETING_SOURCE_CODE_ID MARKETING_SOURCE_CODE_ID
, QUOTE_LINES.PRICE_LIST_ID PRICE_LIST_ID
, I_PRICE_LISTS.NAME PRICE_LIST_NAME
, QUOTE_LINES.PRICE_LIST_LINE_ID PRICE_LIST_LINE_ID
, QUOTE_LINES.CURRENCY_CODE CURRENCY_CODE
, QUOTE_LINES.LINE_LIST_PRICE LINE_LIST_PRICE
, QUOTE_LINES.LINE_ADJUSTED_AMOUNT LINE_ADJUSTED_AMOUNT
, QUOTE_LINES.LINE_ADJUSTED_PERCENT LINE_ADJUSTED_PERCENT
, QUOTE_LINES.LINE_QUOTE_PRICE LINE_QUOTE_PRICE
, QUOTE_LINES.RELATED_ITEM_ID RELATED_ITEM_ID
, QUOTE_LINES.ITEM_RELATIONSHIP_TYPE ITEM_RELATIONSHIP_TYPE
, QUOTE_LINES.ACCOUNTING_RULE_ID ACCOUNTING_RULE_ID
, QUOTE_LINES.INVOICING_RULE_ID INVOICING_RULE_ID
, QUOTE_LINES.SPLIT_SHIPMENT_FLAG SPLIT_SHIPMENT_FLAG
, QUOTE_LINES.BACKORDER_FLAG BACKORDER_FLAG
, QUOTE_DETAILS.QUOTE_LINE_DETAIL_ID QUOTE_LINE_DETAIL_ID
, QUOTE_DETAILS.SERVICE_COTERMINATE_FLAG SERVICE_COTERMINATE_FLAG
, QUOTE_DETAILS.SERVICE_DURATION SERVICE_DURATION
, QUOTE_DETAILS.SERVICE_UNIT_SELLING_PERCENT SERVICE_UNIT_SELLING_PERCENT
, QUOTE_DETAILS.SERVICE_UNIT_LIST_PERCENT SERVICE_UNIT_LIST_PERCENT
, QUOTE_DETAILS.SERVICE_NUMBER SERVICE_NUMBER
, QUOTE_DETAILS.SERVICE_REF_TYPE_CODE
, QUOTE_DETAILS.SERVICE_REF_LINE_ID
, QUOTE_DETAILS.SERVICE_REF_SYSTEM_ID
, QUOTE_DETAILS.UNIT_PERCENT_BASE_PRICE UNIT_PERCENT_BASE_PRICE
, QUOTE_DETAILS.SERVICE_PERIOD SERVICE_PERIOD
, QUOTE_LINES.ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, QUOTE_LINES.ATTRIBUTE1 ATTRIBUTE1
, QUOTE_LINES.ATTRIBUTE2 ATTRIBUTE2
, QUOTE_LINES.ATTRIBUTE3 ATTRIBUTE3
, QUOTE_LINES.ATTRIBUTE4 ATTRIBUTE4
, QUOTE_LINES.ATTRIBUTE5 ATTRIBUTE5
, QUOTE_LINES.PRICED_PRICE_LIST_ID PRICED_PRICE_LIST_ID
, QUOTE_LINES.ATTRIBUTE6 ATTRIBUTE6
, QUOTE_LINES.AGREEMENT_ID AGREEMENT_ID
, QUOTE_LINES.COMMITMENT_ID COMMITMENT_ID
, QUOTE_LINES.ATTRIBUTE7 ATTRIBUTE7
, QUOTE_LINES.ATTRIBUTE8 ATTRIBUTE8
, QUOTE_LINES.ATTRIBUTE9 ATTRIBUTE9
, QUOTE_LINES.ATTRIBUTE10 ATTRIBUTE10
, QUOTE_LINES.ATTRIBUTE11 ATTRIBUTE11
, QUOTE_LINES.ATTRIBUTE12 ATTRIBUTE12
, QUOTE_LINES.ATTRIBUTE13 ATTRIBUTE13
, QUOTE_LINES.ATTRIBUTE14 ATTRIBUTE14
, QUOTE_LINES.ATTRIBUTE15 ATTRIBUTE15
, ITEMS.CONCATENATED_SEGMENTS INVENTORY_ITEM
, ITEMS.PADDED_CONCATENATED_SEGMENTS
, ITEMS.DESCRIPTION ITEM_DESCRIPTION
, ITEMS.SHIPPABLE_ITEM_FLAG
, QUOTE_LINES. LINE_QUOTE_PRICE * QUOTE_LINES.QUANTITY LINE_EXTENDED_PRICE
, QUOTE_DETAILS.CONFIG_HEADER_ID
, QUOTE_DETAILS.CONFIG_REVISION_NUM
, QUOTE_DETAILS.COMPLETE_CONFIGURATION_FLAG
, QUOTE_DETAILS.VALID_CONFIGURATION_FLAG
, QUOTE_LINES.INVOICE_TO_PARTY_SITE_ID
, QUOTE_LINES.INVOICE_TO_PARTY_ID
, QUOTE_LINES.INVOICE_TO_CUST_ACCOUNT_ID
, DECODE(QUOTE_LINES.INVOICE_TO_CUST_ACCOUNT_ID
, NULL
, TO_NUMBER(NULL)
, I_CUST_PARTIES.PARTY_ID)
, DECODE(QUOTE_LINES.INVOICE_TO_CUST_ACCOUNT_ID
, NULL
, NULL
, I_CUST_PARTIES.PARTY_NAME)
, DECODE(QUOTE_LINES.INVOICE_TO_CUST_ACCOUNT_ID
, NULL
, NULL
, I_CUST_PARTIES.PARTY_TYPE)
, DECODE(QUOTE_LINES.INVOICE_TO_CUST_ACCOUNT_ID
, NULL
, NULL
, I_CUST.ACCOUNT_NUMBER)
, I_PARTY_REL_PARTY.PARTY_NAME INVOICE_TO_PARTY_NAME
, I_INV_ADDR.ADDRESS1 INVOICE_TO_ADDRESS1
, I_INV_ADDR.ADDRESS2 INVOICE_TO_ADDRESS2
, I_INV_ADDR.ADDRESS3 INVOICE_TO_ADDRESS3
, I_INV_ADDR.ADDRESS4 INVOICE_TO_ADDRESS4
, I_INV_ADDR.COUNTRY INVOICE_TO_COUNTRY_CODE
, FND_TERRITORIES_VL.TERRITORY_SHORT_NAME INVOICE_TO_COUNTRY
, I_INV_ADDR.CITY INVOICE_TO_CITY
, I_INV_ADDR.POSTAL_CODE INVOICE_TO_POSTAL_CODE
, I_INV_ADDR.STATE INVOICE_TO_STATE
, I_INV_ADDR.PROVINCE INVOICE_TO_PROVINCE
, I_INV_ADDR.COUNTY INVOICE_TO_COUNTY
FROM ASO_QUOTE_LINES_ALL QUOTE_LINES
, ASO_I_PRICE_LISTS_V I_PRICE_LISTS
, ASO_QUOTE_LINE_DETAILS QUOTE_DETAILS
, MTL_SYSTEM_ITEMS_VL ITEMS
, ASO_LOOKUPS LOOKUP
, ASO_QUOTE_HEADERS_ALL ASO_QUOTES
, HZ_PARTY_SITES I_INV_SITE
, HZ_LOCATIONS I_INV_ADDR
, HZ_PARTIES I_INV_PARTIES
, HZ_RELATIONSHIPS I_PARTY_REL
, HZ_PARTIES I_PARTY_REL_PARTY
, HZ_CUST_ACCOUNTS I_CUST
, HZ_PARTIES I_CUST_PARTIES
, FND_TERRITORIES_VL
WHERE QUOTE_LINES.PRICE_LIST_ID = I_PRICE_LISTS.PRICE_LIST_ID(+)
AND QUOTE_LINES.QUOTE_LINE_ID = QUOTE_DETAILS.QUOTE_LINE_ID(+)
AND QUOTE_LINES.INVENTORY_ITEM_ID = ITEMS.INVENTORY_ITEM_ID
AND QUOTE_LINES.ORGANIZATION_ID = ITEMS.ORGANIZATION_ID
AND LOOKUP.LOOKUP_TYPE = 'ASO_ITEM_TYPE'
AND LOOKUP.LOOKUP_CODE = QUOTE_LINES.ITEM_TYPE_CODE
AND QUOTE_LINES.INVOICE_TO_PARTY_SITE_ID = I_INV_SITE.PARTY_SITE_ID(+)
AND I_INV_SITE.LOCATION_ID = I_INV_ADDR.LOCATION_ID(+)
AND I_INV_ADDR.COUNTRY = FND_TERRITORIES_VL.TERRITORY_CODE(+)
AND QUOTE_LINES.INVOICE_TO_PARTY_ID = I_INV_PARTIES.PARTY_ID(+)
AND I_INV_PARTIES.PARTY_ID = I_PARTY_REL.PARTY_ID(+)
AND I_PARTY_REL.SUBJECT_ID = I_PARTY_REL_PARTY.PARTY_ID(+)
AND I_PARTY_REL.SUBJECT_TYPE(+) = 'PERSON'
AND I_PARTY_REL.SUBJECT_TABLE_NAME(+) = 'HZ_PARTIES'
AND NVL(I_PARTY_REL.OBJECT_ID
, I_CUST.PARTY_ID) = I_CUST.PARTY_ID
AND QUOTE_LINES.QUOTE_HEADER_ID = ASO_QUOTES.QUOTE_HEADER_ID
AND NVL(QUOTE_LINES.INVOICE_TO_CUST_ACCOUNT_ID
, ASO_QUOTES.CUST_ACCOUNT_ID) = I_CUST.CUST_ACCOUNT_ID
AND I_CUST.PARTY_ID = I_CUST_PARTIES.PARTY_ID

Columns