eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IBE_WORKFLOW_PVT dependencies on OE_TOTALS_GRP

Line 135: oe_totals_grp.Get_Order_Total(oh.header_id,null,'ALL')order_total,

131: Cursor c_order_header (c_order_id NUMBER) IS
132: SELECT oh.ordered_date,
133: oh.order_number,
134: sold_to_party.party_name customer_name,
135: oe_totals_grp.Get_Order_Total(oh.header_id,null,'ALL')order_total,
136: oe_totals_grp.Get_Order_Total(oh.header_id,null,'CHARGES')charges_total,
137: oe_totals_grp.Get_Order_Total(oh.header_id,null,'TAXES')taxes_total,
138: oe_totals_grp.Get_Order_Total(oh.header_id,null,'LINES')lines_total,
139: sold_to_party.party_id,

Line 136: oe_totals_grp.Get_Order_Total(oh.header_id,null,'CHARGES')charges_total,

132: SELECT oh.ordered_date,
133: oh.order_number,
134: sold_to_party.party_name customer_name,
135: oe_totals_grp.Get_Order_Total(oh.header_id,null,'ALL')order_total,
136: oe_totals_grp.Get_Order_Total(oh.header_id,null,'CHARGES')charges_total,
137: oe_totals_grp.Get_Order_Total(oh.header_id,null,'TAXES')taxes_total,
138: oe_totals_grp.Get_Order_Total(oh.header_id,null,'LINES')lines_total,
139: sold_to_party.party_id,
140: oh.payment_type_code,

Line 137: oe_totals_grp.Get_Order_Total(oh.header_id,null,'TAXES')taxes_total,

133: oh.order_number,
134: sold_to_party.party_name customer_name,
135: oe_totals_grp.Get_Order_Total(oh.header_id,null,'ALL')order_total,
136: oe_totals_grp.Get_Order_Total(oh.header_id,null,'CHARGES')charges_total,
137: oe_totals_grp.Get_Order_Total(oh.header_id,null,'TAXES')taxes_total,
138: oe_totals_grp.Get_Order_Total(oh.header_id,null,'LINES')lines_total,
139: sold_to_party.party_id,
140: oh.payment_type_code,
141: oh.cust_po_number,

Line 138: oe_totals_grp.Get_Order_Total(oh.header_id,null,'LINES')lines_total,

134: sold_to_party.party_name customer_name,
135: oe_totals_grp.Get_Order_Total(oh.header_id,null,'ALL')order_total,
136: oe_totals_grp.Get_Order_Total(oh.header_id,null,'CHARGES')charges_total,
137: oe_totals_grp.Get_Order_Total(oh.header_id,null,'TAXES')taxes_total,
138: oe_totals_grp.Get_Order_Total(oh.header_id,null,'LINES')lines_total,
139: sold_to_party.party_id,
140: oh.payment_type_code,
141: oh.cust_po_number,
142: substr(oh.credit_card_number,(length(oh.credit_card_number)-3),4)credit_card_number,

Line 194: oe_totals_grp.Get_Order_Total(ol.header_id,ol.line_id,'LINES') lines_total,

190: ol.top_model_line_id,
191: ol.link_to_line_id,
192: msi.description item_description,
193: ol.ordered_quantity,
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

Line 195: oe_totals_grp.Get_Order_Total(ol.header_id,ol.line_id,'TAXES') taxes_total,

191: ol.link_to_line_id,
192: msi.description item_description,
193: ol.ordered_quantity,
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

Line 196: oe_totals_grp.Get_Order_Total(ol.header_id,ol.line_id,'CHARGES') charges_total,

192: msi.description item_description,
193: ol.ordered_quantity,
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

Line 197: oe_totals_grp.Get_Order_Total(ol.header_id,ol.line_id,'ALL') extended_price

193: ol.ordered_quantity,
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)

Line 7198: oe_totals_grp.Get_Order_Total(ol.header_id,ol.line_id,'LINES') lines_total,

7194: linetyp.name action,
7195: ol.order_quantity_uom unit_of_measure,
7196: ol.ordered_quantity quantity,
7197: msit1.UNIT_OF_MEASURE charge_periodicity_desc,
7198: oe_totals_grp.Get_Order_Total(ol.header_id,ol.line_id,'LINES') lines_total,
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

Line 7199: oe_totals_grp.Get_Order_Total(ol.header_id,ol.line_id,'TAXES') taxes_total,

7195: ol.order_quantity_uom unit_of_measure,
7196: ol.ordered_quantity quantity,
7197: msit1.UNIT_OF_MEASURE charge_periodicity_desc,
7198: oe_totals_grp.Get_Order_Total(ol.header_id,ol.line_id,'LINES') lines_total,
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,

Line 7236: oe_totals_grp.Get_Order_Total(ol.header_id,ol.line_id,'LINES') lines_total,

7232: linetyp.name action,
7233: ol.order_quantity_uom unit_of_measure,
7234: ol.ordered_quantity quantity,
7235: msit1.UNIT_OF_MEASURE charge_periodicity_desc,
7236: oe_totals_grp.Get_Order_Total(ol.header_id,ol.line_id,'LINES') lines_total,
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

Line 7237: oe_totals_grp.Get_Order_Total(ol.header_id,ol.line_id,'TAXES') taxes_total,

7233: ol.order_quantity_uom unit_of_measure,
7234: ol.ordered_quantity quantity,
7235: msit1.UNIT_OF_MEASURE charge_periodicity_desc,
7236: oe_totals_grp.Get_Order_Total(ol.header_id,ol.line_id,'LINES') lines_total,
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,

Line 8260: Select oe_totals_grp.Get_PayNow_Total(oh.header_id,null,'LINES') PayNow_lines_total,

8256: l_paynow varchar2(1);
8257: l_reccharge varchar2(1);
8258:
8259: Cursor c_macd_order_header (c_order_id NUMBER) IS
8260: Select oe_totals_grp.Get_PayNow_Total(oh.header_id,null,'LINES') PayNow_lines_total,
8261: oe_totals_grp.Get_PayNow_Total(oh.header_id,null,'CHARGES') PayNow_charges_total,
8262: oe_totals_grp.Get_PayNow_Total(oh.header_id,null,'TAXES') PayNow_taxes_total,
8263: oe_totals_grp.Get_PayNow_Total(oh.header_id,null,'ALL') PayNow_order_total,
8264: oh.transactional_curr_code,

Line 8261: oe_totals_grp.Get_PayNow_Total(oh.header_id,null,'CHARGES') PayNow_charges_total,

8257: l_reccharge varchar2(1);
8258:
8259: Cursor c_macd_order_header (c_order_id NUMBER) IS
8260: Select oe_totals_grp.Get_PayNow_Total(oh.header_id,null,'LINES') PayNow_lines_total,
8261: oe_totals_grp.Get_PayNow_Total(oh.header_id,null,'CHARGES') PayNow_charges_total,
8262: oe_totals_grp.Get_PayNow_Total(oh.header_id,null,'TAXES') PayNow_taxes_total,
8263: oe_totals_grp.Get_PayNow_Total(oh.header_id,null,'ALL') PayNow_order_total,
8264: oh.transactional_curr_code,
8265: oe_totals_grp.Get_Order_Total(oh.header_id,null,'ALL') order_total,

Line 8262: oe_totals_grp.Get_PayNow_Total(oh.header_id,null,'TAXES') PayNow_taxes_total,

8258:
8259: Cursor c_macd_order_header (c_order_id NUMBER) IS
8260: Select oe_totals_grp.Get_PayNow_Total(oh.header_id,null,'LINES') PayNow_lines_total,
8261: oe_totals_grp.Get_PayNow_Total(oh.header_id,null,'CHARGES') PayNow_charges_total,
8262: oe_totals_grp.Get_PayNow_Total(oh.header_id,null,'TAXES') PayNow_taxes_total,
8263: oe_totals_grp.Get_PayNow_Total(oh.header_id,null,'ALL') PayNow_order_total,
8264: oh.transactional_curr_code,
8265: oe_totals_grp.Get_Order_Total(oh.header_id,null,'ALL') order_total,
8266: oh.order_number

Line 8263: oe_totals_grp.Get_PayNow_Total(oh.header_id,null,'ALL') PayNow_order_total,

8259: Cursor c_macd_order_header (c_order_id NUMBER) IS
8260: Select oe_totals_grp.Get_PayNow_Total(oh.header_id,null,'LINES') PayNow_lines_total,
8261: oe_totals_grp.Get_PayNow_Total(oh.header_id,null,'CHARGES') PayNow_charges_total,
8262: oe_totals_grp.Get_PayNow_Total(oh.header_id,null,'TAXES') PayNow_taxes_total,
8263: oe_totals_grp.Get_PayNow_Total(oh.header_id,null,'ALL') PayNow_order_total,
8264: oh.transactional_curr_code,
8265: oe_totals_grp.Get_Order_Total(oh.header_id,null,'ALL') order_total,
8266: oh.order_number
8267: from oe_order_headers_all oh

Line 8265: oe_totals_grp.Get_Order_Total(oh.header_id,null,'ALL') order_total,

8261: oe_totals_grp.Get_PayNow_Total(oh.header_id,null,'CHARGES') PayNow_charges_total,
8262: oe_totals_grp.Get_PayNow_Total(oh.header_id,null,'TAXES') PayNow_taxes_total,
8263: oe_totals_grp.Get_PayNow_Total(oh.header_id,null,'ALL') PayNow_order_total,
8264: oh.transactional_curr_code,
8265: oe_totals_grp.Get_Order_Total(oh.header_id,null,'ALL') order_total,
8266: oh.order_number
8267: from oe_order_headers_all oh
8268: where oh.header_id = c_order_id;
8269: g_macd_ord_rec c_macd_order_header%ROWTYPE;

Line 8354: OE_Totals_GRP.GET_RECURRING_TOTALS

8350: l_can_amt := ibe_util.nls_number_format(p_number_in => to_char(g_macd_ord_rec.order_total));
8351: l_document := l_document|| lpad(l_temp_str,51,' ')|| ' '|| lpad(l_curr_sym||to_char(to_number(l_can_amt), l_amt_format), 20, ' ')||NEWLINE;
8352:
8353: --Call OM to find the recurring totals
8354: OE_Totals_GRP.GET_RECURRING_TOTALS
8355: (
8356: p_header_id => l_order_id,
8357: x_rec_charges_tbl => l_rec_charge_tbl
8358: );