VIEW: APPS.CSD_ESTIMATE_DETAILS_EXT_V

Source

View Text - Preformatted

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'

View Text - HTML Formatted

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'