[Home] [Help]
197: oe_totals_grp.Get_Order_Total(ol.header_id,ol.line_id,'ALL') extended_price
198: FROM oe_order_lines_all ol, mtl_system_items_tl msi
199: WHERE ol.header_id = p_order_id
200: and ol.inventory_item_id = msi.inventory_item_id
201: and msi.organization_id = oe_profile.value('OE_ORGANIZATION_ID', ol.org_id)
202: and msi.language = userenv('LANG')
203: ORDER BY line_number, shipment_number,nvl(option_number,-1), nvl(component_number,-1), nvl(service_number,-1);
204:
205: Cursor c_contract_rep (p_org_id NUMBER) IS
7209: 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'
7210: and ol.inventory_item_id = msi.inventory_item_Id
7211: and msit1.language(+) = userenv('LANG')
7212: and ol.charge_periodicity_code = msit1.uom_code(+)
7213: and msi.organization_id = oe_profile.value('OE_ORGANIZATION_ID', ol.org_id)
7214: and ol.config_header_id = cfgdtl.config_hdr_id(+)
7215: and ol.config_rev_nbr = cfgdtl.config_rev_nbr (+)
7216: and ol.configuration_id = cfgdtl.config_item_id(+)
7217: AND ol.line_type_id = linetyp.transaction_type_id
7248: and ( top_model_line_id = p_mdl_top_line_id)
7249: and ol.inventory_item_id = msi.inventory_item_Id
7250: and msit1.language(+) = userenv('LANG')
7251: and ol.charge_periodicity_code = msit1.uom_code(+)
7252: and msi.organization_id = oe_profile.value('OE_ORGANIZATION_ID', ol.org_id)
7253: and ol.config_header_id = cfgdtl.config_hdr_id(+)
7254: and ol.config_rev_nbr = cfgdtl.config_rev_nbr (+)
7255: and ol.configuration_id = cfgdtl.config_item_id(+)
7256: AND ol.line_type_id = linetyp.transaction_type_id