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 ASO_QUOTE_HEADERS_ALL

Line 241: FROM aso_quote_headers_all

237: invoice_to_cust_account_id,
238: total_adjusted_amount,
239: currency_code,
240: resource_id
241: FROM aso_quote_headers_all
242: WHERE quote_header_id = p_quote_id;
243: g_quote_header_rec c_quote_header%ROWTYPE;
244:
245: Cursor c_quote_detail (p_quote_id NUMBER) IS

Line 297: from aso_quote_headers_all

293: WHERE fc.currency_code = p_currCode;
294:
295: Cursor c_get_source_code(p_quote_id NUMBER) is
296: select quote_source_code
297: from aso_quote_headers_all
298: where quote_header_id = p_quote_id;
299:
300: g_curr_sym FND_CURRENCIES.SYMBOL%TYPE;
301: g_amt_format VARCHAR2(20);

Line 475: from aso_quote_headers_all

471: Procedure identify_cart_quote(p_quote_header_id IN NUMBER
472: ,x_is_it_quote OUT NOCOPY VARCHAR2) is
473: cursor c_get_cart_type(c_quote_header_id NUMBER) is
474: select resource_id
475: from aso_quote_headers_all
476: where quote_header_id = c_quote_header_id;
477:
478: rec_get_cart_type c_get_cart_type%rowtype;
479: l_is_it_quote VARCHAR2(1) := fnd_api.g_false;

Line 4646: l_quote_name ASO_QUOTE_HEADERS_ALL.QUOTE_NAME%TYPE;

4642: l_item_owner WF_USERS.NAME%TYPE := 'SYSADMIN';
4643: l_user_name WF_USERS.NAME%TYPE;
4644: l_usertype Varchar2(30) := FND_API.G_MISS_CHAR;
4645: l_notification_preference WF_USERS.NOTIFICATION_PREFERENCE%TYPE;
4646: l_quote_name ASO_QUOTE_HEADERS_ALL.QUOTE_NAME%TYPE;
4647: l_quote_Num ASO_QUOTE_HEADERS_ALL.QUOTE_NUMBER%TYPE;
4648: l_quote_ver ASO_QUOTE_HEADERS_ALL.QUOTE_VERSION%TYPE;
4649: l_msite_name IBE_MSITES_VL.MSITE_NAME%TYPE;
4650: l_cart_name ASO_QUOTE_HEADERS_ALL.QUOTE_NAME%TYPE;

Line 4647: l_quote_Num ASO_QUOTE_HEADERS_ALL.QUOTE_NUMBER%TYPE;

4643: l_user_name WF_USERS.NAME%TYPE;
4644: l_usertype Varchar2(30) := FND_API.G_MISS_CHAR;
4645: l_notification_preference WF_USERS.NOTIFICATION_PREFERENCE%TYPE;
4646: l_quote_name ASO_QUOTE_HEADERS_ALL.QUOTE_NAME%TYPE;
4647: l_quote_Num ASO_QUOTE_HEADERS_ALL.QUOTE_NUMBER%TYPE;
4648: l_quote_ver ASO_QUOTE_HEADERS_ALL.QUOTE_VERSION%TYPE;
4649: l_msite_name IBE_MSITES_VL.MSITE_NAME%TYPE;
4650: l_cart_name ASO_QUOTE_HEADERS_ALL.QUOTE_NAME%TYPE;
4651: l_is_it_quote VARCHAR2(1) := FND_API.G_FALSE;

Line 4648: l_quote_ver ASO_QUOTE_HEADERS_ALL.QUOTE_VERSION%TYPE;

4644: l_usertype Varchar2(30) := FND_API.G_MISS_CHAR;
4645: l_notification_preference WF_USERS.NOTIFICATION_PREFERENCE%TYPE;
4646: l_quote_name ASO_QUOTE_HEADERS_ALL.QUOTE_NAME%TYPE;
4647: l_quote_Num ASO_QUOTE_HEADERS_ALL.QUOTE_NUMBER%TYPE;
4648: l_quote_ver ASO_QUOTE_HEADERS_ALL.QUOTE_VERSION%TYPE;
4649: l_msite_name IBE_MSITES_VL.MSITE_NAME%TYPE;
4650: l_cart_name ASO_QUOTE_HEADERS_ALL.QUOTE_NAME%TYPE;
4651: l_is_it_quote VARCHAR2(1) := FND_API.G_FALSE;
4652: x_contact_first_name HZ_PARTIES.PERSON_FIRST_NAME%TYPE;

Line 4650: l_cart_name ASO_QUOTE_HEADERS_ALL.QUOTE_NAME%TYPE;

4646: l_quote_name ASO_QUOTE_HEADERS_ALL.QUOTE_NAME%TYPE;
4647: l_quote_Num ASO_QUOTE_HEADERS_ALL.QUOTE_NUMBER%TYPE;
4648: l_quote_ver ASO_QUOTE_HEADERS_ALL.QUOTE_VERSION%TYPE;
4649: l_msite_name IBE_MSITES_VL.MSITE_NAME%TYPE;
4650: l_cart_name ASO_QUOTE_HEADERS_ALL.QUOTE_NAME%TYPE;
4651: l_is_it_quote VARCHAR2(1) := FND_API.G_FALSE;
4652: x_contact_first_name HZ_PARTIES.PERSON_FIRST_NAME%TYPE;
4653: x_contact_last_name HZ_PARTIES.PERSON_LAST_NAME%TYPE;
4654: l_recip_name Varchar2(2000);

Line 4663: from aso_quote_headers_all

4659: WHERE msite_id = p_msite;
4660:
4661: CURSOR c_b2c_sharing(c_retrieval_number number) is
4662: select quote_name
4663: from aso_quote_headers_all
4664: where quote_header_id = (select quote_header_id
4665: from ibe_sh_quote_access
4666: where quote_sharee_number = c_retrieval_number);
4667: CURSOR c_get_recip_name(c_retrieval_number number) is

Line 4847: l_cart_name ASO_QUOTE_HEADERS_ALL.QUOTE_NAME%TYPE;

4843: l_item_owner WF_USERS.NAME%TYPE := 'SYSADMIN';
4844: l_user_name WF_USERS.NAME%TYPE;
4845: l_notification_preference WF_USERS.NOTIFICATION_PREFERENCE%TYPE ;
4846: l_msite_name IBE_MSITES_VL.MSITE_NAME%TYPE;
4847: l_cart_name ASO_QUOTE_HEADERS_ALL.QUOTE_NAME%TYPE;
4848: l_is_it_quote VARCHAR2(1) := FND_API.G_FALSE;
4849:
4850: l_sharedby_first_name HZ_PARTIES.PERSON_FIRST_NAME%TYPE;
4851: l_sharedby_last_name HZ_PARTIES.PERSON_LAST_NAME%TYPE;

Line 5082: l_cart_name ASO_QUOTE_HEADERS_ALL.QUOTE_NAME%TYPE;

5078: l_item_owner WF_USERS.NAME%TYPE := 'SYSADMIN';
5079: l_user_name WF_USERS.NAME%TYPE;
5080: l_notification_preference WF_USERS.NOTIFICATION_PREFERENCE%TYPE ;
5081: l_msite_name IBE_MSITES_VL.MSITE_NAME%TYPE;
5082: l_cart_name ASO_QUOTE_HEADERS_ALL.QUOTE_NAME%TYPE;
5083: l_is_it_quote VARCHAR2(1) := FND_API.G_FALSE;
5084:
5085: l_sharedby_first_name HZ_PARTIES.PERSON_FIRST_NAME%TYPE;
5086: l_sharedby_last_name HZ_PARTIES.PERSON_LAST_NAME%TYPE;

Line 5336: l_cart_name ASO_QUOTE_HEADERS_ALL.QUOTE_NAME%TYPE;

5332: l_item_owner WF_USERS.NAME%TYPE := 'SYSADMIN';
5333: l_user_name WF_USERS.NAME%TYPE;
5334: l_notification_preference WF_USERS.NOTIFICATION_PREFERENCE%TYPE ;
5335: l_msite_name IBE_MSITES_VL.MSITE_NAME%TYPE;
5336: l_cart_name ASO_QUOTE_HEADERS_ALL.QUOTE_NAME%TYPE;
5337: l_is_it_quote varchar2(1) := FND_API.G_FALSE;
5338:
5339: l_sharedby_first_name HZ_PARTIES.PERSON_FIRST_NAME%TYPE;
5340: l_sharedby_last_name HZ_PARTIES.PERSON_LAST_NAME%TYPE;

Line 5562: from aso_quote_headers_all

5558: ) is
5559:
5560: cursor c_quote_name(c_qte_header_id number) is
5561: select quote_name
5562: from aso_quote_headers_all
5563: where quote_header_id = c_qte_header_id;
5564:
5565: cursor c_get_email(c_contact_point_id NUMBER) is
5566: select email_address

Line 9214: from aso_quote_lines_all ql,aso_quote_headers_all qh

9210: Cursor c_macd_quote_footer(c_quote_id NUMBER) IS
9211: select nvl(sum(ql.line_paynow_subtotal),'0.00')paynow_lines_total,nvl(sum(ql.line_paynow_charges),'0.00')paynow_charges_total,nvl(sum(ql.line_paynow_tax),'0.00')paynow_taxes_total,
9212: nvl(sum(ql.line_paynow_subtotal + ql.line_paynow_charges + ql.line_paynow_tax),'0.00')paynow_order_total,
9213: qh.total_quote_price quote_total,qh.currency_code
9214: from aso_quote_lines_all ql,aso_quote_headers_all qh
9215: where qh.quote_header_id = c_quote_id
9216: and ql.quote_header_id = qh.quote_header_id
9217: group by ql.quote_header_id,qh.total_quote_price,qh.currency_code;
9218: g_macd_quote_rec c_macd_quote_footer%ROWTYPE;