eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

View: XNC_QUOTE_PARAMS_V

Product:	XNC - Sales for Communications (Obsolete)
Description:	XNC_QUOTE_PARAMS_V retrieves parameter definition information for an item on a quote line.
Implementation/DBA Data:	Not implemented in this database

View Text

SELECT NVL(AQLAE.ROWID
, NULL) ROW_ID
, NVL(AQLAE.LINE_ATTRIBUTE_ID
, NULL)
, NVL(AQLAE.VALUE
, NULL)
, AQLAE.VALUE_TYPE
, AQLAE.ATTRIBUTE_TYPE_CODE
, AQLAE.STATUS
, AQLAE.APPLICATION_ID
, AQLAE.QUOTE_SHIPMENT_ID
, XIAP.PARAMETER_NAME
, XIAP.PARAMETER_MEANING
, XIAP.PARAMETER_DESCRIPTION
, DECODE(XIAP.SOURCE_TYPE_CODE
, 'XNC_PARS_SRC_CUSTOMER'
, LKPC.MEANING
, 'XNC_PARS_SRC_ENUMERATED'
, LKPE.MEANING
, 'XNC_PARS_SRC_API'
, LKPD.MEANING
, XIAP.SOURCE_TYPE_MEANING) SOURCE
, XIAP.SOURCE_NAME
, XIAP.ITEM_ACTION_PARAM_ID
, XIAP.ITEM_ACTION_ID
, XIAP.INVENTORY_ITEM_ID
, XIAP.ORGANIZATION_ID
, XIAP.ACTION_TYPE
, XIAP.SUB_ACTION_TYPE
, XIAP.ACTION_NAME
, XIAP.ITEM_NAME
, XIAP.ITEM_DESCRIPTION
, XIAP.ACTION_DESCRIPTION
, XIAP.SYNCHRONOUS_ACTION_FLAG
, XIAP.MANDATORY_FLAG
, XIAP.SUBSCRIPTION_FLAG
, XIAP.DEFAULT_VALUE
, XIAP.DISPLAY_FLAG
, XIAP.DISPLAY_MEANING
, XIAP.SEQUENCE
, XIAP.SYSTEM_DEFINED_FLAG
, XIAP.START_DATE_ACTIVE
, XIAP.END_DATE_ACTIVE
, AQL.QUOTE_HEADER_ID
, AQL.QUOTE_LINE_ID
FROM FND_LOOKUP_VALUES_VL LKPE
, FND_LOOKUP_VALUES_VL LKPC
, FND_LOOKUP_VALUES_VL LKPD
, ASO_QUOTE_LINE_ATTRIBS_EXT AQLAE
, XNC_ITEM_ACTION_PARS_V XIAP
, ASO_QUOTE_LINES_ALL AQL
WHERE AQL.INVENTORY_ITEM_ID = XIAP.INVENTORY_ITEM_ID
AND AQL.ORGANIZATION_ID = XIAP.ORGANIZATION_ID
AND XIAP.SYNCHRONOUS_ACTION_FLAG = 'Y'
AND XIAP.DISPLAY_FLAG IN ('B'
, 'C')
AND (SYSDATE BETWEEN NVL(XIAP.START_DATE_ACTIVE
, SYSDATE)
AND NVL(XIAP.END_DATE_ACTIVE
, SYSDATE))
AND AQL.QUOTE_LINE_ID = AQLAE.QUOTE_LINE_ID
AND XIAP.PARAMETER_NAME = NVL(AQLAE.NAME
, XIAP.PARAMETER_NAME)
AND (SYSDATE BETWEEN NVL(AQLAE.START_DATE_ACTIVE
, SYSDATE)
AND NVL(AQLAE.END_DATE_ACTIVE
, SYSDATE))
AND LKPC.VIEW_APPLICATION_ID = 532
AND LKPC.LOOKUP_TYPE = 'XNC_ACTION_PAR_VALUE_SOURCE'
AND LKPC.LOOKUP_CODE = 'CUSTOMER'
AND LKPE.VIEW_APPLICATION_ID = 532
AND LKPE.LOOKUP_TYPE = 'XNC_ACTION_PAR_VALUE_SOURCE'
AND LKPE.LOOKUP_CODE = 'ENUMERATED'
AND LKPD.VIEW_APPLICATION_ID = 532
AND LKPD.LOOKUP_TYPE = 'XNC_ACTION_PAR_VALUE_SOURCE'
AND LKPD.LOOKUP_CODE = 'API'

Columns

Name
ROW_ID
LINE_ATTRIBUTE_ID
VALUE
VALUE_TYPE
ATTRIBUTE_TYPE_CODE
STATUS
APPLICATION_ID
QUOTE_SHIPMENT_ID
NAME
PARAMETER_MEANING
PARAMETER_DESCRIPTION
SOURCE
SOURCE_NAME
ITEM_ACTION_PARAM_ID
ITEM_ACTION_ID
INVENTORY_ITEM_ID
ORGANIZATION_ID
ACTION_TYPE
SUB_ACTION_TYPE
ACTION_NAME
ITEM_NAME
ITEM_DESCRIPTION
ACTION_DESCRIPTION
SYNCHRONOUS_ACTION_FLAG
MANDATORY_FLAG
SUBSCRIPTION_FLAG
DEFAULT_VALUE
DISPLAY_FLAG
DISPLAY_MEANING
SEQUENCE
SYSTEM_DEFINED_FLAG
START_DATE_ACTIVE
END_DATE_ACTIVE
QUOTE_HEADER_ID
QUOTE_LINE_ID