VIEW: APPS.ASO_PVT_QUOTE_LINES_BALI_V

Source

View Text - Preformatted

SELECT ROW_ID, QUOTE_LINE_ID, ASO_LINE_NUM_INT.ASO_QUOTE_LINE_NUMBER (QUOTE_LINE_ID, ITEM_TYPE_CODE, SERVICEABLE_PRODUCT_FLAG, SERVICE_ITEM_FLAG, SERVICE_REF_TYPE_CODE, CONFIG_HEADER_ID, CONFIG_REVISION_NUM) UI_LINE_NUMBER, QUOTE_HEADER_ID, ORG_ID, LINE_CATEGORY_CODE, ITEM_TYPE_CODE, INVENTORY_ITEM_TYPE, LINE_NUMBER, ORDER_LINE_TYPE_ID, ORGANIZATION_ID, INVENTORY_ITEM_ID, INVENTORY_ITEM, PADDED_CONCATENATED_SEGMENTS, ITEM_DESCRIPTION, INDENTED_ITEM_DESCRIPTION, QUANTITY, UOM_CODE, PRICE_LIST_ID, PRICE_LIST_LINE_ID, CURRENCY_CODE, LINE_LIST_PRICE, LINE_ADJUSTED_AMOUNT, LINE_ADJUSTED_PERCENT, LINE_QUOTE_PRICE, EXTENDED_LIST_PRICE, EXTENDED_ADJUSTED_AMOUNT, EXTENDED_SELLING_PRICE, START_DATE_ACTIVE, END_DATE_ACTIVE, INVOICE_TO_PARTY_SITE_ID, INVOICE_TO_PARTY_ID, INVOICE_TO_CUST_PARTY_ID, MARKETING_SOURCE_CODE_ID, RELATED_ITEM_ID, ITEM_RELATIONSHIP_TYPE, ACCOUNTING_RULE_ID, INVOICING_RULE_ID, SPLIT_SHIPMENT_FLAG, BACKORDER_FLAG, SECURITY_GROUP_ID, OBJECT_VERSION_NUMBER, INVOICE_TO_CUST_ACCOUNT_ID, MINISITE_ID, SECTION_ID, PRICED_PRICE_LIST_ID, AGREEMENT_ID, COMMITMENT_ID, DISPLAY_ARITHMETIC_OPERATOR, LINE_TYPE_SOURCE_FLAG, CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN, REQUEST_ID, PROGRAM_APPLICATION_ID, PROGRAM_ID, PROGRAM_UPDATE_DATE, ATTRIBUTE1, ATTRIBUTE2, ATTRIBUTE3, ATTRIBUTE4, ATTRIBUTE5, ATTRIBUTE6, ATTRIBUTE7, ATTRIBUTE8, ATTRIBUTE9, ATTRIBUTE10, ATTRIBUTE11, ATTRIBUTE12, ATTRIBUTE13, ATTRIBUTE14, ATTRIBUTE15, ATTRIBUTE16, ATTRIBUTE17, ATTRIBUTE18, ATTRIBUTE19, ATTRIBUTE20, ATTRIBUTE_CATEGORY, SELLING_PRICE_CHANGE, RECALCULATE_FLAG, PRICING_LINE_TYPE_INDICATOR, END_CUSTOMER_PARTY_ID, END_CUSTOMER_CUST_PARTY_ID, END_CUSTOMER_PARTY_SITE_ID, END_CUSTOMER_CUST_ACCOUNT_ID, CHARGE_PERIODICITY_CODE, SHIP_MODEL_COMPLETE_FLAG, LINE_PAYNOW_CHARGES, LINE_PAYNOW_TAX, LINE_PAYNOW_SUBTOTAL, CHARGE_PERIODICITY_MEANING, QUOTE_LINE_DETAIL_ID, CONFIG_HEADER_ID, CONFIG_REVISION_NUM, CONFIG_ITEM_ID, COMPLETE_CONFIGURATION_FLAG, VALID_CONFIGURATION_FLAG, COMPONENT_CODE, SERVICE_COTERMINATE_FLAG, SERVICE_DURATION, SERVICE_UNIT_SELLING_PERCENT, SERVICE_UNIT_LIST_PERCENT, SERVICE_NUMBER, SERVICE_PERIOD, SERVICE_REF_TYPE_CODE, SERVICE_REF_ORDER_NUMBER, SERVICE_REF_LINE_NUMBER, SERVICE_REF_LINE_ID, SERVICE_REF_SYSTEM_ID, UNIT_PERCENT_BASE_PRICE, SERVICE_REF_OPTION_NUMB, SERVICE_REF_SHIPMENT_NUMB, RETURN_REF_TYPE, RETURN_REF_HEADER_ID, RETURN_REF_LINE_ID, RETURN_REASON_CODE, REF_TYPE_CODE, REF_LINE_ID, INSTANCE_ID, BOM_SORT_ORDER, CONFIG_DELTA, CONFIG_INSTANCE_NAME, SERVICEABLE_PRODUCT_FLAG, SERVICE_ITEM_FLAG, TOP_MODEL_LINE_ID, ATO_LINE_ID, COMPONENT_SEQUENCE_ID, SHIP_QUOTE_PRICE, MODEL_STATUS, CONFIG_MODEL_TYPE FROM ASO_PVT_QUOTE_LINES_NUM_V

View Text - HTML Formatted

SELECT ROW_ID
, QUOTE_LINE_ID
, ASO_LINE_NUM_INT.ASO_QUOTE_LINE_NUMBER (QUOTE_LINE_ID
, ITEM_TYPE_CODE
, SERVICEABLE_PRODUCT_FLAG
, SERVICE_ITEM_FLAG
, SERVICE_REF_TYPE_CODE
, CONFIG_HEADER_ID
, CONFIG_REVISION_NUM) UI_LINE_NUMBER
, QUOTE_HEADER_ID
, ORG_ID
, LINE_CATEGORY_CODE
, ITEM_TYPE_CODE
, INVENTORY_ITEM_TYPE
, LINE_NUMBER
, ORDER_LINE_TYPE_ID
, ORGANIZATION_ID
, INVENTORY_ITEM_ID
, INVENTORY_ITEM
, PADDED_CONCATENATED_SEGMENTS
, ITEM_DESCRIPTION
, INDENTED_ITEM_DESCRIPTION
, QUANTITY
, UOM_CODE
, PRICE_LIST_ID
, PRICE_LIST_LINE_ID
, CURRENCY_CODE
, LINE_LIST_PRICE
, LINE_ADJUSTED_AMOUNT
, LINE_ADJUSTED_PERCENT
, LINE_QUOTE_PRICE
, EXTENDED_LIST_PRICE
, EXTENDED_ADJUSTED_AMOUNT
, EXTENDED_SELLING_PRICE
, START_DATE_ACTIVE
, END_DATE_ACTIVE
, INVOICE_TO_PARTY_SITE_ID
, INVOICE_TO_PARTY_ID
, INVOICE_TO_CUST_PARTY_ID
, MARKETING_SOURCE_CODE_ID
, RELATED_ITEM_ID
, ITEM_RELATIONSHIP_TYPE
, ACCOUNTING_RULE_ID
, INVOICING_RULE_ID
, SPLIT_SHIPMENT_FLAG
, BACKORDER_FLAG
, SECURITY_GROUP_ID
, OBJECT_VERSION_NUMBER
, INVOICE_TO_CUST_ACCOUNT_ID
, MINISITE_ID
, SECTION_ID
, PRICED_PRICE_LIST_ID
, AGREEMENT_ID
, COMMITMENT_ID
, DISPLAY_ARITHMETIC_OPERATOR
, LINE_TYPE_SOURCE_FLAG
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, REQUEST_ID
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, ATTRIBUTE16
, ATTRIBUTE17
, ATTRIBUTE18
, ATTRIBUTE19
, ATTRIBUTE20
, ATTRIBUTE_CATEGORY
, SELLING_PRICE_CHANGE
, RECALCULATE_FLAG
, PRICING_LINE_TYPE_INDICATOR
, END_CUSTOMER_PARTY_ID
, END_CUSTOMER_CUST_PARTY_ID
, END_CUSTOMER_PARTY_SITE_ID
, END_CUSTOMER_CUST_ACCOUNT_ID
, CHARGE_PERIODICITY_CODE
, SHIP_MODEL_COMPLETE_FLAG
, LINE_PAYNOW_CHARGES
, LINE_PAYNOW_TAX
, LINE_PAYNOW_SUBTOTAL
, CHARGE_PERIODICITY_MEANING
, QUOTE_LINE_DETAIL_ID
, CONFIG_HEADER_ID
, CONFIG_REVISION_NUM
, CONFIG_ITEM_ID
, COMPLETE_CONFIGURATION_FLAG
, VALID_CONFIGURATION_FLAG
, COMPONENT_CODE
, SERVICE_COTERMINATE_FLAG
, SERVICE_DURATION
, SERVICE_UNIT_SELLING_PERCENT
, SERVICE_UNIT_LIST_PERCENT
, SERVICE_NUMBER
, SERVICE_PERIOD
, SERVICE_REF_TYPE_CODE
, SERVICE_REF_ORDER_NUMBER
, SERVICE_REF_LINE_NUMBER
, SERVICE_REF_LINE_ID
, SERVICE_REF_SYSTEM_ID
, UNIT_PERCENT_BASE_PRICE
, SERVICE_REF_OPTION_NUMB
, SERVICE_REF_SHIPMENT_NUMB
, RETURN_REF_TYPE
, RETURN_REF_HEADER_ID
, RETURN_REF_LINE_ID
, RETURN_REASON_CODE
, REF_TYPE_CODE
, REF_LINE_ID
, INSTANCE_ID
, BOM_SORT_ORDER
, CONFIG_DELTA
, CONFIG_INSTANCE_NAME
, SERVICEABLE_PRODUCT_FLAG
, SERVICE_ITEM_FLAG
, TOP_MODEL_LINE_ID
, ATO_LINE_ID
, COMPONENT_SEQUENCE_ID
, SHIP_QUOTE_PRICE
, MODEL_STATUS
, CONFIG_MODEL_TYPE
FROM ASO_PVT_QUOTE_LINES_NUM_V