APPS.IBE_WORKFLOW_PVT dependencies on OE_ORDER_LINES_ALL

Line 208: FROM oe_order_lines_all ol, mtl_system_items_tl msi

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

Line 7168: FROM oe_order_lines_all line,

7164: l_view_net_price_flag VARCHAR2(1);
7165: l_view_line_type_flag VARCHAR2(1) := FND_API.G_FALSE;
7166: Cursor c_ship_flag(p_line_id NUMBER) IS
7167: SELECT msi.shippable_item_flag
7168: FROM oe_order_lines_all line,
7169: OE_SYSTEM_PARAMETERS_ALL osp,
7170: mtl_system_items_kfv msi
7171: WHERE line.line_id = p_line_id
7172: AND line.org_id = osp.org_id

Line 7298: FROM oe_order_lines_all ol,

7294: oe_totals_grp.Get_Order_Total(ol.header_id,ol.line_id,'TAXES') taxes_total,
7295: ol.shippable_flag,
7296: decode(msi.config_model_type,'N','Y','N') model_container_flag,
7297: cfgdtl.config_delta config_delta_flag
7298: FROM oe_order_lines_all ol,
7299: mtl_system_items_vl msi,
7300: CZ_CONFIG_ITEMS cfgdtl,
7301: mtl_units_of_measure_tl msit1,
7302: oe_transaction_types_tl linetyp

Line 7336: FROM oe_order_lines_all ol,

7332: oe_totals_grp.Get_Order_Total(ol.header_id,ol.line_id,'TAXES') taxes_total,
7333: ol.shippable_flag,
7334: decode(msi.config_model_type,'N','Y','N') model_container_flag,
7335: cfgdtl.config_delta config_delta_flag
7336: FROM oe_order_lines_all ol,
7337: mtl_system_items_vl msi,
7338: CZ_CONFIG_ITEMS cfgdtl,
7339: mtl_units_of_measure_tl msit1,
7340: oe_transaction_types_tl linetyp

Line 8196: FROM oe_order_lines_all line, OE_SYSTEM_PARAMETERS_ALL osp,

8192: l_view_net_price_flag VARCHAR2(1);
8193:
8194: Cursor c_ship_flag(p_line_id NUMBER) IS
8195: SELECT msi.shippable_item_flag
8196: FROM oe_order_lines_all line, OE_SYSTEM_PARAMETERS_ALL osp,
8197: mtl_system_items_kfv msi
8198: WHERE line.line_id = p_line_id
8199: AND line.org_id = osp.org_id
8200: AND osp.master_organization_id = msi.organization_id