View: OKX_QUOTE_LINES_V

Product:	OKX - Contracts Integration
Description:	Quote line information
Implementation/DBA Data:	APPS.OKX_QUOTE_LINES_V

View Text

SELECT LIN.QUOTE_LINE_ID ID1
, '#' ID2
, LIN.QUOTE_HEADER_ID QUOTE_HEADER_ID
, LIN.ORG_ID ORG_ID
, LIN.LINE_CATEGORY_CODE LINE_CATEGORY_CODE
, LIN.ITEM_TYPE_CODE ITEM_TYPE_CODE
, LIN.LINE_NUMBER LINE_NUMBER
, LIN.START_DATE_ACTIVE START_DATE_ACTIVE
, LIN.END_DATE_ACTIVE END_DATE_ACTIVE
, LIN.CURRENCY_CODE CURRENCY_CODE
, LIN.ORDER_LINE_TYPE_ID ORDER_LINE_TYPE_ID
, LIN.ORGANIZATION_ID ORGANIZATION_ID
, LIN.INVENTORY_ITEM_ID INVENTORY_ITEM_ID
, LIN.QUANTITY QUANTITY
, LIN.UOM_CODE UOM_CODE
, DECODE(SIGN(TRUNC(SYSDATE)-NVL(LIN.START_DATE_ACTIVE
, TRUNC(SYSDATE)))
, -1
, 'I'
, DECODE(SIGN(TRUNC(SYSDATE) - NVL(LIN.END_DATE_ACTIVE
, TRUNC(SYSDATE)))
, 1
, 'I'
, 'A')) STATUS
, NULL NAME
, NULL DESCRIPTION
, LIN.LINE_LIST_PRICE LINE_LIST_PRICE
, LIN.AGREEMENT_ID AGREEMENT_ID
, LIN.LINE_QUOTE_PRICE LINE_QUOTE_PRICE
, LIN.PRICE_LIST_ID PRICE_LIST_ID
, LIN.PRICE_LIST_LINE_ID PRICE_LIST_LINE_ID
, LIN.INVOICING_RULE_ID INVOICING_RULE_ID
, LIN.INVOICE_TO_PARTY_SITE_ID INVOICE_TO_PARTY_SITE_ID
, LIN.INVOICE_TO_PARTY_ID INVOICE_TO_PARTY_ID
, LIN.INVOICE_TO_CUST_ACCOUNT_ID
FROM ASO_QUOTE_LINES_ALL LIN

Columns