APPS.IBE_WORKFLOW_PVT dependencies on OE_ORDER_LINES_ALL

Line 198: FROM oe_order_lines_all ol, mtl_system_items_tl msi

194: oe_totals_grp.Get_Order_Total(ol.header_id,ol.line_id,'LINES') lines_total,
195: oe_totals_grp.Get_Order_Total(ol.header_id,ol.line_id,'TAXES') taxes_total,
196: oe_totals_grp.Get_Order_Total(ol.header_id,ol.line_id,'CHARGES') charges_total,
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')

Line 7073: FROM oe_order_lines_all line,

7069: l_view_net_price_flag VARCHAR2(1);
7070: l_view_line_type_flag VARCHAR2(1) := FND_API.G_FALSE;
7071: Cursor c_ship_flag(p_line_id NUMBER) IS
7072: SELECT msi.shippable_item_flag
7073: FROM oe_order_lines_all line,
7074: OE_SYSTEM_PARAMETERS_ALL osp,
7075: mtl_system_items_kfv msi
7076: WHERE line.line_id = p_line_id
7077: AND line.org_id = osp.org_id

Line 7203: FROM oe_order_lines_all ol,

7199: oe_totals_grp.Get_Order_Total(ol.header_id,ol.line_id,'TAXES') taxes_total,
7200: ol.shippable_flag,
7201: decode(msi.config_model_type,'N','Y','N') model_container_flag,
7202: cfgdtl.config_delta config_delta_flag
7203: FROM oe_order_lines_all ol,
7204: mtl_system_items_vl msi,
7205: CZ_CONFIG_ITEMS cfgdtl,
7206: mtl_units_of_measure_tl msit1,
7207: oe_transaction_types_tl linetyp

Line 7241: FROM oe_order_lines_all ol,

7237: oe_totals_grp.Get_Order_Total(ol.header_id,ol.line_id,'TAXES') taxes_total,
7238: ol.shippable_flag,
7239: decode(msi.config_model_type,'N','Y','N') model_container_flag,
7240: cfgdtl.config_delta config_delta_flag
7241: FROM oe_order_lines_all ol,
7242: mtl_system_items_vl msi,
7243: CZ_CONFIG_ITEMS cfgdtl,
7244: mtl_units_of_measure_tl msit1,
7245: oe_transaction_types_tl linetyp

Line 8101: FROM oe_order_lines_all line, OE_SYSTEM_PARAMETERS_ALL osp,

8097: l_view_net_price_flag VARCHAR2(1);
8098:
8099: Cursor c_ship_flag(p_line_id NUMBER) IS
8100: SELECT msi.shippable_item_flag
8101: FROM oe_order_lines_all line, OE_SYSTEM_PARAMETERS_ALL osp,
8102: mtl_system_items_kfv msi
8103: WHERE line.line_id = p_line_id
8104: AND line.org_id = osp.org_id
8105: AND osp.master_organization_id = msi.organization_id