Varun Blogs

--- Price List Query select LH.name, (select Flex_Value  from apps.FND_FLEX_VALUES_VL where flex_value_set_id=1009583 and description=LH.name) ValueSetCode, LH.currency_code, msib.segment1  ITEM, LL.operand PRICE, LL.start_date_active, LL.end_date_active, (Select user_name||'.'||description from applsys.FND_user where user_id = LL.last_updated_by) Last_Updated_by, (Select user_name||'.'||description from applsys.FND_user where user_id = LL.created_by) created_by, trunc(LL.creation_date) Created_on from apps.qp_secu_list_headers_v LH, apps.qp_list_lines_v LL, apps.mtl_system_items_b msib where LH.List_header_id=LL.List_header_id --and --LL.end_date_active = '31-DEC-2012' ---and (select segment1 from apps.mtl_system_items_b where organization_id = 89 and inventory_item_id = LL.product_id) in  ('29024468','29026516','29026519') and LH.list_header_id = (select list_header_id from apps.qp_secu_list_headers_v where name = ...

-- Order Details select --* ol.line_id, --oh.sold_to_org_id, oh.created_by, (select user_name from apps.fnd_user where user_id = oh.created_by) created_name, c.account_number, d.party_name "Cust Name", --oh.ship_to_org_id, oh.invoice_to_org_id, hl1.country "ShipCountry",hcas1.attribute17, hl2.country "BillCountry",hcas2.attribute17, oh.transactional_curr_code curr, oh.org_id, (select name from apps.hr_operating_units where organization_id = oh.org_id) "OU", oh.order_number, --oh.header_id, oh.creation_date, tt.name "OrderType", --oh.order_source_id,   oh.open_flag, oh.booked_flag,   oh.CUST_PO_NUMBER, --oh.shipping_method_code, (select wcsv.ship_method_meaning from apps.WSH_CARRIER_SERVICES_V wcsv where wcsv.ship_method_code = oh.shipping_method_code) HEADER_SHIP_METHOD, --ol.line_id, ol.line_number||'.'||ol.shipment_number "line", ol.ordered_item, --msieb.C_EXT_ATTR26 APC_WM_ST...