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_LINE_DETAILS

Line 5927: update aso_quote_line_details

5923: if (l_qte_line_rec.item_type_code='MDL') and (i=1) then
5924: IF aso_debug_pub.g_debug_flag = 'Y' THEN
5925: aso_debug_pub.add('Create_Quote: After call to Create_Quote_Lines updating the data for MDL line');
5926: end if;
5927: update aso_quote_line_details
5928: set top_model_line_id=l_top_model_line_id,ato_line_id=l_ato_line_id
5929: where quote_line_id=l_qte_line_rec.quote_line_id;
5930: end if;
5931:

Line 6127: update aso_quote_line_details

6123: END IF;
6124:
6125: if l_line_rltship_rec.relationship_type_code = 'CONFIG' then
6126:
6127: update aso_quote_line_details
6128: set ref_type_code = 'CONFIG',
6129: ref_line_id = l_line_rltship_rec.quote_line_id,
6130: last_update_date = sysdate,
6131: last_updated_by = fnd_global.user_id,

Line 6143: update aso_quote_line_details

6139: IF aso_debug_pub.g_debug_flag = 'Y' THEN
6140: aso_debug_pub.add('Create_Quote: x_qte_header_rec.quote_header_id: '|| x_qte_header_rec.quote_header_id);
6141: END IF;
6142:
6143: update aso_quote_line_details
6144: set ref_type_code = 'CONFIG',
6145: last_update_date = sysdate,
6146: last_updated_by = fnd_global.user_id,
6147: last_update_login = fnd_global.conc_login_id

Line 6920: select quote_line_id from aso_quote_line_details

6916: l_config_revision_num number;
6917: l_new_config_hdr_id number;
6918:
6919: cursor c_model_line (p_config_header_id NUMBER, p_config_revision_num NUMBER)is
6920: select quote_line_id from aso_quote_line_details
6921: where config_header_id = p_config_header_id
6922: and config_revision_num = p_config_revision_num
6923: and ref_type_code = 'CONFIG'
6924: and ref_line_id is NULL;

Line 7072: FROM aso_quote_line_details a1,

7068: SELECT a1.quote_line_id,
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');

Line 7112: from aso_quote_line_Details

7108: l_return_value Varchar2(1);
7109:
7110: cursor c_service_ref_quote (P_Quote_line_id number) is
7111: select service_ref_line_id
7112: from aso_quote_line_Details
7113: where quote_line_id= P_Quote_line_id
7114: and service_ref_type_code ='QUOTE';
7115:
7116: l_line_dtl_tbl aso_quote_pub.qte_line_dtl_tbl_type := aso_quote_pub.g_miss_qte_line_dtl_tbl;

Line 7131: from aso_quote_line_details

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
7132: where quote_line_id = P_Quote_line_id;
7133:
7134: l_service_ref_type_code aso_quote_line_details.service_ref_type_code%Type;
7135:

Line 7134: l_service_ref_type_code aso_quote_line_details.service_ref_type_code%Type;

7130: select service_ref_type_code
7131: from aso_quote_line_details
7132: where quote_line_id = P_Quote_line_id;
7133:
7134: l_service_ref_type_code aso_quote_line_details.service_ref_type_code%Type;
7135:
7136: /* End : Code change for Bug 9847694 */
7137:
7138: -- bug 10261431

Line 8007: FROM aso_quote_line_details a1,

8003: -- Checking if lines table has service reference CUSTOMER_PRODUCT,PRODUCT_CATALOG
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');

Line 10139: update aso_quote_line_details

10135: if (l_qte_line_rec.item_type_code='MDL') and (i=1) then
10136: IF aso_debug_pub.g_debug_flag = 'Y' THEN
10137: aso_debug_pub.add('Update_Quote: After call to Create_Quote_Lines updating the data for MDL line');
10138: end if;
10139: update aso_quote_line_details
10140: set top_model_line_id=l_top_model_line_id,ato_line_id=l_ato_line_id
10141: where quote_line_id=l_qte_line_rec.quote_line_id;
10142: end if;
10143: -- P1 bug 10261431

Line 10614: select quote_line_id from aso_quote_line_Details

10610: aso_debug_pub.add('Update_Quote: Reverse Limits for handling CFG items');
10611: END IF;
10612: for c1 in
10613: (
10614: select quote_line_id from aso_quote_line_Details
10615: where ref_type_code='CONFIG'
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: )

Line 11069: update aso_quote_line_details

11065: if l_line_rltship_rec.relationship_type_code = 'CONFIG' and
11066: (l_line_rltship_rec.operation_code = 'CREATE' or
11067: l_line_rltship_rec.operation_code = 'UPDATE') then
11068:
11069: update aso_quote_line_details
11070: set ref_type_code = 'CONFIG',
11071: ref_line_id = l_line_rltship_rec.quote_line_id,
11072: last_update_date = sysdate,
11073: last_updated_by = g_user_id,

Line 11085: update aso_quote_line_details

11081: IF aso_debug_pub.g_debug_flag = 'Y' THEN
11082: aso_debug_pub.add('Update_Quote: x_qte_header_rec.quote_header_id: '|| x_qte_header_rec.quote_header_id);
11083: END IF;
11084:
11085: update aso_quote_line_details
11086: set ref_type_code = 'CONFIG',
11087: last_update_date = sysdate,
11088: last_updated_by = g_user_id,
11089: last_update_login = g_login_id

Line 13183: SELECT ASO_Quote_Line_Details.QUOTE_LINE_ID

13179: )
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

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 13185: WHERE ASO_Quote_Line_Details.config_header_id = p_old_config_header_id

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'
13189: AND aso_quote_lines_all.quote_header_id = qte_header_id;

Line 13186: AND ASO_Quote_Line_Details.config_revision_num = p_old_config_revision_num

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'
13189: AND aso_quote_lines_all.quote_header_id = qte_header_id;
13190:

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;