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 251: FROM aso_quote_headers_all

247: invoice_to_cust_account_id,
248: total_adjusted_amount,
249: currency_code,
250: resource_id
251: FROM aso_quote_headers_all
252: WHERE quote_header_id = p_quote_id;
253: g_quote_header_rec c_quote_header%ROWTYPE;
254:
255: Cursor c_quote_detail (p_quote_id NUMBER) IS

Line 307: from aso_quote_headers_all

303: WHERE fc.currency_code = p_currCode;
304:
305: Cursor c_get_source_code(p_quote_id NUMBER) is
306: select quote_source_code
307: from aso_quote_headers_all
308: where quote_header_id = p_quote_id;
309:
310: g_curr_sym FND_CURRENCIES.SYMBOL%TYPE;
311: g_amt_format VARCHAR2(20);

Line 485: from aso_quote_headers_all

481: Procedure identify_cart_quote(p_quote_header_id IN NUMBER
482: ,x_is_it_quote OUT NOCOPY VARCHAR2) is
483: cursor c_get_cart_type(c_quote_header_id NUMBER) is
484: select resource_id
485: from aso_quote_headers_all
486: where quote_header_id = c_quote_header_id;
487:
488: rec_get_cart_type c_get_cart_type%rowtype;
489: l_is_it_quote VARCHAR2(1) := fnd_api.g_false;

Line 4741: l_quote_name ASO_QUOTE_HEADERS_ALL.QUOTE_NAME%TYPE;

4737: l_item_owner WF_USERS.NAME%TYPE := 'SYSADMIN';
4738: l_user_name WF_USERS.NAME%TYPE;
4739: l_usertype jtf_um_usertypes_b.usertype_key%type := FND_API.G_MISS_CHAR;
4740: l_notification_preference WF_USERS.NOTIFICATION_PREFERENCE%TYPE;
4741: l_quote_name ASO_QUOTE_HEADERS_ALL.QUOTE_NAME%TYPE;
4742: l_quote_Num ASO_QUOTE_HEADERS_ALL.QUOTE_NUMBER%TYPE;
4743: l_quote_ver ASO_QUOTE_HEADERS_ALL.QUOTE_VERSION%TYPE;
4744: l_msite_name IBE_MSITES_VL.MSITE_NAME%TYPE;
4745: l_cart_name ASO_QUOTE_HEADERS_ALL.QUOTE_NAME%TYPE;

Line 4742: l_quote_Num ASO_QUOTE_HEADERS_ALL.QUOTE_NUMBER%TYPE;

4738: l_user_name WF_USERS.NAME%TYPE;
4739: l_usertype jtf_um_usertypes_b.usertype_key%type := FND_API.G_MISS_CHAR;
4740: l_notification_preference WF_USERS.NOTIFICATION_PREFERENCE%TYPE;
4741: l_quote_name ASO_QUOTE_HEADERS_ALL.QUOTE_NAME%TYPE;
4742: l_quote_Num ASO_QUOTE_HEADERS_ALL.QUOTE_NUMBER%TYPE;
4743: l_quote_ver ASO_QUOTE_HEADERS_ALL.QUOTE_VERSION%TYPE;
4744: l_msite_name IBE_MSITES_VL.MSITE_NAME%TYPE;
4745: l_cart_name ASO_QUOTE_HEADERS_ALL.QUOTE_NAME%TYPE;
4746: l_is_it_quote VARCHAR2(1) := FND_API.G_FALSE;

Line 4743: l_quote_ver ASO_QUOTE_HEADERS_ALL.QUOTE_VERSION%TYPE;

4739: l_usertype jtf_um_usertypes_b.usertype_key%type := FND_API.G_MISS_CHAR;
4740: l_notification_preference WF_USERS.NOTIFICATION_PREFERENCE%TYPE;
4741: l_quote_name ASO_QUOTE_HEADERS_ALL.QUOTE_NAME%TYPE;
4742: l_quote_Num ASO_QUOTE_HEADERS_ALL.QUOTE_NUMBER%TYPE;
4743: l_quote_ver ASO_QUOTE_HEADERS_ALL.QUOTE_VERSION%TYPE;
4744: l_msite_name IBE_MSITES_VL.MSITE_NAME%TYPE;
4745: l_cart_name ASO_QUOTE_HEADERS_ALL.QUOTE_NAME%TYPE;
4746: l_is_it_quote VARCHAR2(1) := FND_API.G_FALSE;
4747: x_contact_first_name HZ_PARTIES.PERSON_FIRST_NAME%TYPE;

Line 4745: l_cart_name ASO_QUOTE_HEADERS_ALL.QUOTE_NAME%TYPE;

4741: l_quote_name ASO_QUOTE_HEADERS_ALL.QUOTE_NAME%TYPE;
4742: l_quote_Num ASO_QUOTE_HEADERS_ALL.QUOTE_NUMBER%TYPE;
4743: l_quote_ver ASO_QUOTE_HEADERS_ALL.QUOTE_VERSION%TYPE;
4744: l_msite_name IBE_MSITES_VL.MSITE_NAME%TYPE;
4745: l_cart_name ASO_QUOTE_HEADERS_ALL.QUOTE_NAME%TYPE;
4746: l_is_it_quote VARCHAR2(1) := FND_API.G_FALSE;
4747: x_contact_first_name HZ_PARTIES.PERSON_FIRST_NAME%TYPE;
4748: x_contact_last_name HZ_PARTIES.PERSON_LAST_NAME%TYPE;
4749: l_recip_name Varchar2(2000);

Line 4758: from aso_quote_headers_all

4754: WHERE msite_id = p_msite;
4755:
4756: CURSOR c_b2c_sharing(c_retrieval_number number) is
4757: select quote_name
4758: from aso_quote_headers_all
4759: where quote_header_id = (select quote_header_id
4760: from ibe_sh_quote_access
4761: where quote_sharee_number = c_retrieval_number);
4762: CURSOR c_get_recip_name(c_retrieval_number number) is

Line 4942: l_cart_name ASO_QUOTE_HEADERS_ALL.QUOTE_NAME%TYPE;

4938: l_item_owner WF_USERS.NAME%TYPE := 'SYSADMIN';
4939: l_user_name WF_USERS.NAME%TYPE;
4940: l_notification_preference WF_USERS.NOTIFICATION_PREFERENCE%TYPE ;
4941: l_msite_name IBE_MSITES_VL.MSITE_NAME%TYPE;
4942: l_cart_name ASO_QUOTE_HEADERS_ALL.QUOTE_NAME%TYPE;
4943: l_is_it_quote VARCHAR2(1) := FND_API.G_FALSE;
4944:
4945: l_sharedby_first_name HZ_PARTIES.PERSON_FIRST_NAME%TYPE;
4946: l_sharedby_last_name HZ_PARTIES.PERSON_LAST_NAME%TYPE;

Line 5177: l_cart_name ASO_QUOTE_HEADERS_ALL.QUOTE_NAME%TYPE;

5173: l_item_owner WF_USERS.NAME%TYPE := 'SYSADMIN';
5174: l_user_name WF_USERS.NAME%TYPE;
5175: l_notification_preference WF_USERS.NOTIFICATION_PREFERENCE%TYPE ;
5176: l_msite_name IBE_MSITES_VL.MSITE_NAME%TYPE;
5177: l_cart_name ASO_QUOTE_HEADERS_ALL.QUOTE_NAME%TYPE;
5178: l_is_it_quote VARCHAR2(1) := FND_API.G_FALSE;
5179:
5180: l_sharedby_first_name HZ_PARTIES.PERSON_FIRST_NAME%TYPE;
5181: l_sharedby_last_name HZ_PARTIES.PERSON_LAST_NAME%TYPE;

Line 5431: l_cart_name ASO_QUOTE_HEADERS_ALL.QUOTE_NAME%TYPE;

5427: l_item_owner WF_USERS.NAME%TYPE := 'SYSADMIN';
5428: l_user_name WF_USERS.NAME%TYPE;
5429: l_notification_preference WF_USERS.NOTIFICATION_PREFERENCE%TYPE ;
5430: l_msite_name IBE_MSITES_VL.MSITE_NAME%TYPE;
5431: l_cart_name ASO_QUOTE_HEADERS_ALL.QUOTE_NAME%TYPE;
5432: l_is_it_quote varchar2(1) := FND_API.G_FALSE;
5433:
5434: l_sharedby_first_name HZ_PARTIES.PERSON_FIRST_NAME%TYPE;
5435: l_sharedby_last_name HZ_PARTIES.PERSON_LAST_NAME%TYPE;

Line 5657: from aso_quote_headers_all

5653: ) is
5654:
5655: cursor c_quote_name(c_qte_header_id number) is
5656: select quote_name
5657: from aso_quote_headers_all
5658: where quote_header_id = c_qte_header_id;
5659:
5660: cursor c_get_email(c_contact_point_id NUMBER) is
5661: select email_address

Line 9309: from aso_quote_lines_all ql,aso_quote_headers_all qh

9305: Cursor c_macd_quote_footer(c_quote_id NUMBER) IS
9306: 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,
9307: nvl(sum(ql.line_paynow_subtotal + ql.line_paynow_charges + ql.line_paynow_tax),'0.00')paynow_order_total,
9308: qh.total_quote_price quote_total,qh.currency_code
9309: from aso_quote_lines_all ql,aso_quote_headers_all qh
9310: where qh.quote_header_id = c_quote_id
9311: and ql.quote_header_id = qh.quote_header_id
9312: group by ql.quote_header_id,qh.total_quote_price,qh.currency_code;
9313: g_macd_quote_rec c_macd_quote_footer%ROWTYPE;