View: CSD_ESTIMATE_DETAILS_EXT_V

Product:	CSD - Depot Repair
Description:
Implementation/DBA Data:	APPS.CSD_ESTIMATE_DETAILS_EXT_V

View Text

SELECT EDT.INCIDENT_ID
, EDT.ESTIMATE_DETAIL_ID
, EDT.SOURCE_CODE
, EDT.SOURCE_ID
, OEH.ORDER_NUMBER
, ITEMS.CONCATENATED_SEGMENTS
, ITEMS.DESCRIPTION
, EDT.QUANTITY_REQUIRED
, EDT.UNIT_OF_MEASURE_CODE
, UOM.UNIT_OF_MEASURE_TL
, EDT.CURRENCY_CODE
, EDT.SERIAL_NUMBER
, CP.INSTANCE_NUMBER
, STT.LINE_ORDER_CATEGORY_CODE
, EDT.INVENTORY_ITEM_ID
, CP.INSTANCE_ID
, EDT.ITEM_REVISION
, EDT.TXN_BILLING_TYPE_ID
, CP.LOT_NUMBER
, EDT.PRICE_LIST_HEADER_ID
, EDT.ORG_ID
FROM CS_ESTIMATE_DETAILS EDT
, CSI_ITEM_INSTANCES CP
, MTL_SYSTEM_ITEMS_VL ITEMS
, MTL_UNITS_OF_MEASURE_VL UOM
, OE_ORDER_HEADERS_ALL OEH
, OE_ORDER_LINES_ALL OEL
, CS_TRANSACTION_TYPES_VL STT
, CS_TXN_BILLING_TYPES SBT
, CS_BILLING_TYPE_CATEGORIES SBC
WHERE EDT.SOURCE_CODE <> 'DR'
AND EDT.ORIGINAL_SOURCE_CODE ='SR' AND EDT.CUSTOMER_PRODUCT_ID = CP.INSTANCE_ID(+) AND EDT.INVENTORY_ITEM_ID = ITEMS.INVENTORY_ITEM_ID AND ITEMS.ORGANIZATION_ID = CS_STD.GET_ITEM_VALDN_ORGZN_ID AND EDT.UNIT_OF_MEASURE_CODE = UOM.UOM_CODE AND SBT.TXN_BILLING_TYPE_ID = EDT.TXN_BILLING_TYPE_ID AND SBT.TRANSACTION_TYPE_ID = STT.TRANSACTION_TYPE_ID AND EDT.ORDER_HEADER_ID = OEH.HEADER_ID AND EDT.ORDER_LINE_ID = OEL.LINE_ID AND SBT.BILLING_TYPE = SBC.BILLING_TYPE AND SBC.BILLING_CATEGORY = 'M'

Columns