ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 8E2FF36EDEE179D2E0530100007F1FF2 INV Organization (ledger dependent) Y select ood.organization_code value, ood.organization_name description from gl_ledgers gl, org_organization_definitions ood where nvl(ood.disable_date,sysdate)>=sysdate and (:$flex$.ledger is null or xxen_util.contains(:$flex$.ledger,gl.name)='Y') and gl.ledger_id=ood.set_of_books_id order by ood.organization_code US 95958B4E4CA46315E053B46B6358D3BE select mp.organization_code, msi.segment1, msi.description, msi.inventory_item_status_Code, msi.creation_date, msi.planner_code, decode(msi.planning_make_buy_code, 1, 'MAKE', 'BUY') Mk_Buy, decode(cic.based_on_rollup_flag, 1, 'Yes', 'No') Based_on_rollup from cst_item_costs cic, mtl_system_items msi, hr_organization_units hou, mtl_parameters mp where 1=1 and msi.organization_id = mp.organization_id and cic.organization_id = msi.organization_id and cic.inventory_item_id = msi.inventory_item_id and cic.cost_type_id = 1 and hou.organization_id = mp.organization_id and msi.costing_enabled_flag = 'Y' and hou.date_to is null and nvl(cic.item_cost,0) = 0 order by msi.segment1, mp.organization_code Y bob.gupta@mail.weir Y US Testing Zero Cost Items SQL Draft 1=1 1 10 1=1 mp.organization_code=:organization_code LOV INV Organization (ledger dependent) 8E2FF36EDEE179D2E0530100007F1FF2 Y select ood.organization_code value, ood.organization_name description from gl_ledgers gl, org_organization_definitions ood where nvl(ood.disable_date,sysdate)>=sysdate and (:$flex$.ledger is null or xxen_util.contains(:$flex$.ledger,gl.name)='Y') and gl.ledger_id=ood.set_of_books_id order by ood.organization_code US Organization Code