VIEW: APPS.OKX_QUOTE_LINES_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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