VIEW: APPS.ASO_PVT_QUOTE_LINES_V

Source

View Text - Preformatted

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 , QUOTE_LINES.ATTRIBUTE16 ATTRIBUTE16 , QUOTE_LINES.ATTRIBUTE17 ATTRIBUTE17 , QUOTE_LINES.ATTRIBUTE18 ATTRIBUTE18 , QUOTE_LINES.ATTRIBUTE19 ATTRIBUTE19 , QUOTE_LINES.ATTRIBUTE20 ATTRIBUTE20 , 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 , I_CUST_PARTIES.PARTY_ID, I_CUST_PARTIES.PARTY_NAME, I_CUST_PARTIES.PARTY_TYPE, 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, QUOTE_LINES.CONFIG_MODEL_TYPE FROM ASO_QUOTE_LINES QUOTE_LINES, ASO_I_PRICE_LISTS_V I_PRICE_LISTS, ASO_QUOTE_LINE_DETAILS QUOTE_DETAILS, MTL_SYSTEM_ITEMS_VL ITEMS, ASO_LOOKUPS LOOKUP, hz_party_sites I_inv_SITE, hz_locations I_inv_ADDR, 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_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 i_party_rel.object_id (+) = QUOTE_LINES.invoice_to_cust_party_id and quote_lines.invoice_TO_CUST_ACCOUNT_ID = I_CUST.CUST_ACCOUNT_ID(+) and quote_lines.invoice_to_cust_party_id = I_CUST_PARTIES.PARTY_ID(+)

View Text - HTML Formatted

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
, QUOTE_LINES.ATTRIBUTE16 ATTRIBUTE16
, QUOTE_LINES.ATTRIBUTE17 ATTRIBUTE17
, QUOTE_LINES.ATTRIBUTE18 ATTRIBUTE18
, QUOTE_LINES.ATTRIBUTE19 ATTRIBUTE19
, QUOTE_LINES.ATTRIBUTE20 ATTRIBUTE20
, 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
, I_CUST_PARTIES.PARTY_ID
, I_CUST_PARTIES.PARTY_NAME
, I_CUST_PARTIES.PARTY_TYPE
, 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
, QUOTE_LINES.CONFIG_MODEL_TYPE
FROM ASO_QUOTE_LINES QUOTE_LINES
, ASO_I_PRICE_LISTS_V I_PRICE_LISTS
, ASO_QUOTE_LINE_DETAILS QUOTE_DETAILS
, MTL_SYSTEM_ITEMS_VL ITEMS
, ASO_LOOKUPS LOOKUP
, HZ_PARTY_SITES I_INV_SITE
, HZ_LOCATIONS I_INV_ADDR
, 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_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 I_PARTY_REL.OBJECT_ID (+) = QUOTE_LINES.INVOICE_TO_CUST_PARTY_ID
AND QUOTE_LINES.INVOICE_TO_CUST_ACCOUNT_ID = I_CUST.CUST_ACCOUNT_ID(+)
AND QUOTE_LINES.INVOICE_TO_CUST_PARTY_ID = I_CUST_PARTIES.PARTY_ID(+)