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.ASO_QUOTE_HEADERS_PVT dependencies on ASO_QUOTE_LINES_ALL

Line 3521: FROM ASO_QUOTE_LINES_ALL

3517: SELECT quote_line_id, line_category_code, round(nvl(line_list_price * quantity, 0),l_precision) total_list_price,
3518: round(nvl(line_adjusted_amount * quantity,
3519: nvl(line_adjusted_percent * line_list_price * quantity, 0)),l_precision) ln_total_discount,
3520: round( nvl(line_quote_price * quantity, 0),l_precision) ln_selling_price
3521: FROM ASO_QUOTE_LINES_ALL
3522: WHERE quote_header_id = p_qte_header_id
3523: and charge_periodicity_code is null; -- Recurring charges Change
3524:
3525: CURSOR c_tax_line(p_quote_line_id NUMBER) IS

Line 4138: from aso_quote_lines_all

4134: and quote_line_id IS NULL ;
4135:
4136: Cursor get_line_qte_price( p_quote_line_id NUMBER) IS
4137: select line_quote_price,quantity
4138: from aso_quote_lines_all
4139: where quote_line_id = p_quote_line_id;
4140:
4141: Cursor c_inv_org_id(l_main_org_id Number) IS
4142: select master_organization_id

Line 6151: and quote_line_id in (select quote_line_id from aso_quote_lines_all

6147: last_update_login = fnd_global.conc_login_id
6148: where config_header_id is not null
6149: and config_revision_num is not null
6150: and ref_type_code is null
6151: and quote_line_id in (select quote_line_id from aso_quote_lines_all
6152: where item_type_code = 'MDL'
6153: and quote_header_id = x_qte_header_rec.quote_header_id);
6154:
6155:

Line 6520: update aso_quote_lines_all

6516: END IF;
6517:
6518:
6519: -- Update the corresponding columns in the line table
6520: update aso_quote_lines_all
6521: set line_paynow_charges = l_paynow_charges,
6522: line_paynow_tax = l_paynow_tax,
6523: line_paynow_subtotal = l_paynow_amount,
6524: last_update_date = sysdate,

Line 6787: SELECT quote_line_id FROM ASO_QUOTE_LINES_ALL

6783: AND quote_line_id IS NULL
6784: AND ORIG_TAX_CODE IS NOT NULL;
6785:
6786: CURSOR c_qte_line(l_d_qte_line NUMBER) IS
6787: SELECT quote_line_id FROM ASO_QUOTE_LINES_ALL
6788: where quote_line_id= l_d_qte_line;
6789:
6790: --ovn
6791: cursor c_last_update_date( p_qte_hdr_id number) is

Line 6798: from aso_quote_lines_all

6794: where quote_header_id = p_qte_hdr_id;
6795:
6796: cursor c_quote_lines( p_qte_hdr_id number) is
6797: select quote_line_id,order_line_type_id,line_category_code,price_list_id,line_quote_price,quantity
6798: from aso_quote_lines_all
6799: where quote_header_id = p_qte_hdr_id;
6800:
6801: cursor c_related_obj_id (p_qte_hdr_id number) is
6802: select related_object_id,last_update_date

Line 7073: aso_quote_lines_all a2

7069: SERVICE_REF_LINE_ID ,
7070: service_ref_type_code ,
7071: a2.inventory_item_id
7072: FROM aso_quote_line_details a1,
7073: aso_quote_lines_all a2
7074: WHERE a2.quote_header_id = p_qte_hdr_id
7075: AND a1.quote_line_id = a2.quote_line_id
7076: AND SERVICE_REF_TYPE_CODE IN ('CUSTOMER_PRODUCT','PRODUCT_CATALOG');
7077:

Line 7124: from aso_quote_lines_all

7120: /* Start : Code change for Bug 9847694 */
7121:
7122: Cursor C_ITEM_TYPE_CODE(P_Quote_line_id Number) Is
7123: select item_type_code
7124: from aso_quote_lines_all
7125: where quote_line_id = P_Quote_line_id;
7126:
7127: l_item_type_code aso_quote_lines_all.item_type_code%Type;
7128:

Line 7127: l_item_type_code aso_quote_lines_all.item_type_code%Type;

7123: select item_type_code
7124: from aso_quote_lines_all
7125: where quote_line_id = P_Quote_line_id;
7126:
7127: l_item_type_code aso_quote_lines_all.item_type_code%Type;
7128:
7129: Cursor C_SERVICE_REF_TYPE_CODE(P_Quote_line_id Number) Is
7130: select service_ref_type_code
7131: from aso_quote_line_details

Line 7147: from aso_quote_lines_all

7143: l_qty number; -- rassharm
7144:
7145: CURSOR c_qte_line_type(l_d_qte_line NUMBER) IS
7146: select item_type_code
7147: from aso_quote_lines_all
7148: where quote_line_id= l_d_qte_line;
7149:
7150: l_item_type_code1 varchar2(30); -- rassharm
7151:

Line 8008: aso_quote_lines_all a2

8004:
8005: SELECT count(*)
8006: INTO ls_count
8007: FROM aso_quote_line_details a1,
8008: aso_quote_lines_all a2
8009: WHERE a2.quote_header_id = l_qte_header_rec.quote_header_id
8010: AND a1.quote_line_id = a2.quote_line_id
8011: AND SERVICE_REF_TYPE_CODE IN ('CUSTOMER_PRODUCT','PRODUCT_CATALOG');
8012:

Line 10620: select nvl(quantity,0) into l_qty from aso_Quote_lines_all where quote_line_id=c1.quote_line_id;

10616: and (top_model_line_id=l_qln_id or ref_line_id=l_qln_id)
10617: and top_model_line_id<>quote_line_id
10618: )
10619: loop
10620: select nvl(quantity,0) into l_qty from aso_Quote_lines_all where quote_line_id=c1.quote_line_id;
10621: aso_debug_pub.add('rassharm Update_Quote: Reverse Limits for handling CFG items quote_line_id'||c1.quote_line_id||' *** qty'||l_qty);
10622: QP_UTIL_PUB.Reverse_Limits (p_action_code => 'CANCEL',
10623: p_cons_price_request_code => 'ASO-'||l_qte_line_rec.quote_header_id||'-'||c1.quote_line_id,
10624: p_orig_ordered_qty => l_qty,

Line 11093: and quote_line_id in (select quote_line_id from aso_quote_lines_all

11089: last_update_login = g_login_id
11090: where config_header_id is not null
11091: and config_revision_num is not null
11092: and ref_type_code is null
11093: and quote_line_id in (select quote_line_id from aso_quote_lines_all
11094: where item_type_code = 'MDL'
11095: and quote_header_id = x_qte_header_rec.quote_header_id);
11096:
11097: IF aso_debug_pub.g_debug_flag = 'Y' THEN

Line 11268: ASO_QUOTE_LINES_ALL

11264: COUNT(QUOTE_HEADER_ID)
11265: INTO
11266: l_lines
11267: FROM
11268: ASO_QUOTE_LINES_ALL
11269: WHERE
11270: QUOTE_HEADER_ID=x_qte_header_rec.quote_header_id;
11271: END IF;
11272:

Line 11524: update aso_quote_lines_all

11520: END IF;
11521:
11522:
11523: -- Update the corresponding columns in the line table
11524: update aso_quote_lines_all
11525: set line_paynow_charges = l_paynow_charges,
11526: line_paynow_tax = l_paynow_tax,
11527: line_paynow_subtotal = l_paynow_amount,
11528: last_update_date = sysdate,

Line 11656: SELECT quote_line_id FROM ASO_QUOTE_LINES_ALL

11652: l_api_name CONSTANT VARCHAR2(30) := 'Delete_quote';
11653: l_api_version_number CONSTANT NUMBER := 1.0;
11654: l_qln_id NUMBER;
11655: CURSOR c_qte_lines IS
11656: SELECT quote_line_id FROM ASO_QUOTE_LINES_ALL
11657: WHERE quote_header_id = p_qte_header_id;
11658:
11659: l_qte_line_rec ASO_QUOTE_PUB.Qte_Line_Rec_Type;
11660: CURSOR c_qte_line(l_d_qte_line NUMBER) IS

Line 11661: SELECT quote_line_id FROM ASO_QUOTE_LINES_ALL

11657: WHERE quote_header_id = p_qte_header_id;
11658:
11659: l_qte_line_rec ASO_QUOTE_PUB.Qte_Line_Rec_Type;
11660: CURSOR c_qte_line(l_d_qte_line NUMBER) IS
11661: SELECT quote_line_id FROM ASO_QUOTE_LINES_ALL
11662: where quote_line_id= l_qte_line_rec.quote_line_id;
11663: BEGIN
11664: -- Standard Start of API savepoint
11665: SAVEPOINT DELETE_quote_PVT;

Line 11889: (SELECT quote_line_id FROM aso_quote_lines_all

11885: RELATED_QUOTE_LINE_ID,
11886: RELATIONSHIP_TYPE_CODE,
11887: RECIPROCAL_FLAG FROM ASO_LINE_RELATIONSHIPS
11888: WHERE quote_line_id IN
11889: (SELECT quote_line_id FROM aso_quote_lines_all
11890: WHERE quote_header_id = x_quote_header_id)
11891: AND related_quote_line_id IN
11892: (SELECT quote_line_id FROM aso_quote_lines_all
11893: WHERE quote_header_id = x_quote_header_id);

Line 11892: (SELECT quote_line_id FROM aso_quote_lines_all

11888: WHERE quote_line_id IN
11889: (SELECT quote_line_id FROM aso_quote_lines_all
11890: WHERE quote_header_id = x_quote_header_id)
11891: AND related_quote_line_id IN
11892: (SELECT quote_line_id FROM aso_quote_lines_all
11893: WHERE quote_header_id = x_quote_header_id);
11894: */ -- original copy_qte
11895:
11896: /* Commented by Biplabi Mishra to change the EXISTS to IN 07/09/01

Line 11915: (SELECT 'x' FROM aso_quote_lines_all aql

11911: RELATED_QUOTE_LINE_ID,
11912: RELATIONSHIP_TYPE_CODE,
11913: RECIPROCAL_FLAG FROM ASO_LINE_RELATIONSHIPS
11914: WHERE EXISTS
11915: (SELECT 'x' FROM aso_quote_lines_all aql
11916: WHERE aql.quote_header_id = x_quote_header_id
11917: AND aql.quote_line_id = aso_line_relationships.quote_line_id)
11918: AND EXISTS
11919: (SELECT 'x' FROM aso_quote_lines_all aql

Line 11919: (SELECT 'x' FROM aso_quote_lines_all aql

11915: (SELECT 'x' FROM aso_quote_lines_all aql
11916: WHERE aql.quote_header_id = x_quote_header_id
11917: AND aql.quote_line_id = aso_line_relationships.quote_line_id)
11918: AND EXISTS
11919: (SELECT 'x' FROM aso_quote_lines_all aql
11920: WHERE aql.quote_header_id = x_quote_header_id
11921: AND aql.quote_line_id = aso_line_relationships.related_quote_line_id);
11922:
11923: */

Line 11951: (SELECT quote_line_id FROM aso_quote_lines_all

11947: WHERE price_adjustment_id IN
11948: (SELECT price_adjustment_id FROM aso_price_adjustments
11949: WHERE quote_header_id = x_quote_header_id)
11950: AND quote_line_id IN
11951: (SELECT quote_line_id FROM aso_quote_lines_all
11952: WHERE quote_header_id = x_quote_header_id);
11953: */
11954: /*
11955: CURSOR c_price_adj_rel (x_quote_header_id NUMBER) IS

Line 11977: AND EXISTS (select 'x' from aso_quote_lines_all aql

11973: FROM ASO_PRICE_ADJ_RELATIONSHIPS apr,
11974: ASO_PRICE_ADJUSTMENTS apa
11975: WHERE apr.price_adjustment_id = apa.price_adjustment_id
11976: AND apa.quote_header_id = x_quote_header_id
11977: AND EXISTS (select 'x' from aso_quote_lines_all aql
11978: where aql.quote_header_id = x_quote_header_id
11979: and aql.quote_line_id = apr.quote_line_id);
11980: */
11981:

Line 13184: FROM ASO_Quote_Line_Details, ASO_Quote_Lines_all

13180: IS
13181:
13182: CURSOR line_id_from_config IS
13183: SELECT ASO_Quote_Line_Details.QUOTE_LINE_ID
13184: FROM ASO_Quote_Line_Details, ASO_Quote_Lines_all
13185: WHERE ASO_Quote_Line_Details.config_header_id = p_old_config_header_id
13186: AND ASO_Quote_Line_Details.config_revision_num = p_old_config_revision_num
13187: AND ASO_quote_line_details.quote_line_id = ASO_Quote_Lines_all.quote_line_id
13188: AND ASO_Quote_Lines_all.item_type_code <> 'MDL'

Line 13187: AND ASO_quote_line_details.quote_line_id = ASO_Quote_Lines_all.quote_line_id

13183: SELECT ASO_Quote_Line_Details.QUOTE_LINE_ID
13184: FROM ASO_Quote_Line_Details, ASO_Quote_Lines_all
13185: WHERE ASO_Quote_Line_Details.config_header_id = p_old_config_header_id
13186: AND ASO_Quote_Line_Details.config_revision_num = p_old_config_revision_num
13187: AND ASO_quote_line_details.quote_line_id = ASO_Quote_Lines_all.quote_line_id
13188: AND ASO_Quote_Lines_all.item_type_code <> 'MDL'
13189: AND aso_quote_lines_all.quote_header_id = qte_header_id;
13190:
13191: l_payment_tbl ASO_QUOTE_PUB.Payment_Tbl_Type;

Line 13188: AND ASO_Quote_Lines_all.item_type_code <> 'MDL'

13184: FROM ASO_Quote_Line_Details, ASO_Quote_Lines_all
13185: WHERE ASO_Quote_Line_Details.config_header_id = p_old_config_header_id
13186: AND ASO_Quote_Line_Details.config_revision_num = p_old_config_revision_num
13187: AND ASO_quote_line_details.quote_line_id = ASO_Quote_Lines_all.quote_line_id
13188: AND ASO_Quote_Lines_all.item_type_code <> 'MDL'
13189: AND aso_quote_lines_all.quote_header_id = qte_header_id;
13190:
13191: l_payment_tbl ASO_QUOTE_PUB.Payment_Tbl_Type;
13192: l_payment_tbl_out ASO_QUOTE_PUB.Payment_Tbl_Type;

Line 13189: AND aso_quote_lines_all.quote_header_id = qte_header_id;

13185: WHERE ASO_Quote_Line_Details.config_header_id = p_old_config_header_id
13186: AND ASO_Quote_Line_Details.config_revision_num = p_old_config_revision_num
13187: AND ASO_quote_line_details.quote_line_id = ASO_Quote_Lines_all.quote_line_id
13188: AND ASO_Quote_Lines_all.item_type_code <> 'MDL'
13189: AND aso_quote_lines_all.quote_header_id = qte_header_id;
13190:
13191: l_payment_tbl ASO_QUOTE_PUB.Payment_Tbl_Type;
13192: l_payment_tbl_out ASO_QUOTE_PUB.Payment_Tbl_Type;
13193: l_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;

Line 13371: p_old_object_code => 'ASO_QUOTE_LINES_ALL',

13367: END IF;
13368:
13369: ASO_ATTACHMENT_INT.Copy_Attachments(
13370: p_api_version => l_api_version,
13371: p_old_object_code => 'ASO_QUOTE_LINES_ALL',
13372: p_new_object_code => 'ASO_QUOTE_LINES_ALL',
13373: p_old_object_id => qte_line_id,
13374: p_new_object_id => lx_qte_line_rec.quote_line_id,
13375: x_return_status => x_return_status ,

Line 13372: p_new_object_code => 'ASO_QUOTE_LINES_ALL',

13368:
13369: ASO_ATTACHMENT_INT.Copy_Attachments(
13370: p_api_version => l_api_version,
13371: p_old_object_code => 'ASO_QUOTE_LINES_ALL',
13372: p_new_object_code => 'ASO_QUOTE_LINES_ALL',
13373: p_old_object_id => qte_line_id,
13374: p_new_object_id => lx_qte_line_rec.quote_line_id,
13375: x_return_status => x_return_status ,
13376: x_msg_count => x_msg_count,

Line 13662: p_old_object_code => 'ASO_QUOTE_LINES_ALL',

13658: END IF;
13659:
13660: ASO_ATTACHMENT_INT.Copy_Attachments(
13661: p_api_version => l_api_version,
13662: p_old_object_code => 'ASO_QUOTE_LINES_ALL',
13663: p_new_object_code => 'ASO_QUOTE_LINES_ALL',
13664: p_old_object_id => qte_line_id,
13665: p_new_object_id => lx_qte_line_rec.quote_line_id,
13666: x_return_status => x_return_status ,

Line 13663: p_new_object_code => 'ASO_QUOTE_LINES_ALL',

13659:
13660: ASO_ATTACHMENT_INT.Copy_Attachments(
13661: p_api_version => l_api_version,
13662: p_old_object_code => 'ASO_QUOTE_LINES_ALL',
13663: p_new_object_code => 'ASO_QUOTE_LINES_ALL',
13664: p_old_object_id => qte_line_id,
13665: p_new_object_id => lx_qte_line_rec.quote_line_id,
13666: x_return_status => x_return_status ,
13667: x_msg_count => x_msg_count,