VIEW: APPS.ASO_PVT_QTE_LINES_PRNT_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_QTE_LINES_PRINT_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_QTE_LINES_PRINT_NUM_V