APPS.IBE_WORKFLOW_PVT dependencies on OE_PROFILE

Line 211: and msi.organization_id = oe_profile.value('OE_ORGANIZATION_ID', ol.org_id)

207: oe_totals_grp.Get_Order_Total(ol.header_id,ol.line_id,'ALL') extended_price
208: FROM oe_order_lines_all ol, mtl_system_items_tl msi
209: WHERE ol.header_id = p_order_id
210: and ol.inventory_item_id = msi.inventory_item_id
211: and msi.organization_id = oe_profile.value('OE_ORGANIZATION_ID', ol.org_id)
212: and msi.language = userenv('LANG')
213: ORDER BY line_number, shipment_number,nvl(option_number,-1), nvl(component_number,-1), nvl(service_number,-1);
214:
215: Cursor c_contract_rep (p_org_id NUMBER) IS

Line 7308: and msi.organization_id = oe_profile.value('OE_ORGANIZATION_ID', ol.org_id)

7304: AND decode(ol.top_model_line_id,null,'1',decode(ol.top_model_line_id,ol.line_id,decode(ol.link_to_line_id,null,'1','2'),'2'))= '1'
7305: and ol.inventory_item_id = msi.inventory_item_Id
7306: and msit1.language(+) = userenv('LANG')
7307: and ol.charge_periodicity_code = msit1.uom_code(+)
7308: and msi.organization_id = oe_profile.value('OE_ORGANIZATION_ID', ol.org_id)
7309: and ol.config_header_id = cfgdtl.config_hdr_id(+)
7310: and ol.config_rev_nbr = cfgdtl.config_rev_nbr (+)
7311: and ol.configuration_id = cfgdtl.config_item_id(+)
7312: AND ol.line_type_id = linetyp.transaction_type_id

Line 7347: and msi.organization_id = oe_profile.value('OE_ORGANIZATION_ID', ol.org_id)

7343: and ( top_model_line_id = p_mdl_top_line_id)
7344: and ol.inventory_item_id = msi.inventory_item_Id
7345: and msit1.language(+) = userenv('LANG')
7346: and ol.charge_periodicity_code = msit1.uom_code(+)
7347: and msi.organization_id = oe_profile.value('OE_ORGANIZATION_ID', ol.org_id)
7348: and ol.config_header_id = cfgdtl.config_hdr_id(+)
7349: and ol.config_rev_nbr = cfgdtl.config_rev_nbr (+)
7350: and ol.configuration_id = cfgdtl.config_item_id(+)
7351: AND ol.line_type_id = linetyp.transaction_type_id