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_LINES_PVT dependencies on ASO_QUOTE_HEADERS_ALL

Line 75: FROM aso_quote_headers_all

71: IS
72:
73: cursor get_quote_number( l_qte_header_id number) is
74: SELECT quote_number
75: FROM aso_quote_headers_all
76: WHERE quote_header_id = l_qte_header_id;
77:
78:
79: G_USER_ID NUMBER := FND_GLOBAL.USER_ID;

Line 1226: FROM aso_quote_headers_all

1222: WHERE quote_line_id = p_qte_line_rec.quote_line_id;
1223:
1224: CURSOR C_customer IS
1225: SELECT cust_account_id, party_id
1226: FROM aso_quote_headers_all
1227: WHERE quote_header_id = p_qte_line_rec.quote_header_id;
1228:
1229: CURSOR C_service_item IS
1230: SELECT qln.start_date_active, qln.end_date_active,

Line 1236: aso_quote_headers_all qhd

1232: detail.service_coterminate_flag,
1233: qhd.cust_account_id, qhd.party_id
1234: FROM aso_quote_lines_all qln,
1235: aso_quote_line_details detail,
1236: aso_quote_headers_all qhd
1237: WHERE detail.quote_line_id = qln.quote_line_id
1238: AND qln.quote_line_id = p_qte_line_rec.quote_line_id
1239: AND qln.quote_header_id = qhd.quote_header_id;
1240:

Line 1243: FROM aso_quote_headers_all

1239: AND qln.quote_header_id = qhd.quote_header_id;
1240:
1241: CURSOR C_org_id IS
1242: SELECT org_id
1243: FROM aso_quote_headers_all
1244: WHERE quote_header_id = p_qte_line_rec.quote_header_id;
1245:
1246: CURSOR c_line_number ( p_quote_line_id NUMBER ) IS
1247: SELECT line_number

Line 2589: From ASO_QUOTE_HEADERS_ALL

2585: IS
2586:
2587: Cursor C_Get_quote(c_QUOTE_HEADER_ID Number) IS
2588: Select LAST_UPDATE_DATE, QUOTE_STATUS_ID, QUOTE_NUMBER, TOTAL_ADJUSTED_PERCENT
2589: From ASO_QUOTE_HEADERS_ALL
2590: Where QUOTE_HEADER_ID = c_QUOTE_HEADER_ID;
2591:
2592: CURSOR C_Qte_Status(c_qte_status_id NUMBER) IS
2593: SELECT UPDATE_ALLOWED_FLAG, AUTO_VERSION_FLAG FROM ASO_QUOTE_STATUSES_B

Line 2598: FROM ASO_QUOTE_HEADERS_ALL

2594: WHERE quote_status_id = c_qte_status_id;
2595:
2596: CURSOR C_Qte_Version (X_qte_number NUMBER) IS
2597: SELECT max(quote_version)
2598: FROM ASO_QUOTE_HEADERS_ALL
2599: WHERE quote_number = X_qte_number;
2600:
2601: CURSOR get_cust_acct(cust_QUOTE_HEADER_ID Number) IS
2602: SELECT CUST_ACCOUNT_ID

Line 2603: FROM ASO_QUOTE_HEADERS_ALL

2599: WHERE quote_number = X_qte_number;
2600:
2601: CURSOR get_cust_acct(cust_QUOTE_HEADER_ID Number) IS
2602: SELECT CUST_ACCOUNT_ID
2603: FROM ASO_QUOTE_HEADERS_ALL
2604: WHERE QUOTE_HEADER_ID = cust_QUOTE_HEADER_ID;
2605:
2606: CURSOR c_reservation(C_inv_item_id NUMBER,C_Organization_id NUMBER) IS
2607: SELECT INVENTORY_ITEM_ID,ORGANIZATION_ID FROM mtl_system_items_b

Line 2616: From ASO_QUOTE_HEADERS_ALL

2612:
2613:
2614: Cursor C_exp_date(c_QUOTE_HEADER_ID Number) IS
2615: Select quote_expiration_date
2616: From ASO_QUOTE_HEADERS_ALL
2617: Where QUOTE_HEADER_ID = c_QUOTE_HEADER_ID;
2618:
2619: CURSOR C_org_id IS
2620: SELECT org_id

Line 2621: FROM aso_quote_headers_all

2617: Where QUOTE_HEADER_ID = c_QUOTE_HEADER_ID;
2618:
2619: CURSOR C_org_id IS
2620: SELECT org_id
2621: FROM aso_quote_headers_all
2622: WHERE quote_header_id = p_qte_line_rec.quote_header_id;
2623:
2624: cursor c_service (p_qln_id number)is
2625: select service_item_flag,serviceable_product_flag

Line 2646: SELECT org_id,quote_type FROM aso_quote_headers_all

2642: AND ORGANIZATION_ID = C_Organization_id;
2643:
2644:
2645: CURSOR c_header_org IS
2646: SELECT org_id,quote_type FROM aso_quote_headers_all
2647: WHERE quote_header_id = P_qte_line_rec.quote_header_id;
2648:
2649:
2650:

Line 2952: update aso_quote_headers_all

2948: x_return_status := FND_API.G_RET_STS_ERROR;
2949:
2950: END IF;
2951:
2952: update aso_quote_headers_all
2953: set quote_version = l_quote_version + 1,
2954: max_version_flag = 'Y',
2955: last_update_date = sysdate,
2956: last_updated_by = fnd_global.user_id,

Line 2960: update aso_quote_headers_all

2956: last_updated_by = fnd_global.user_id,
2957: last_update_login = fnd_global.conc_login_id
2958: where quote_header_id = p_qte_line_rec.quote_header_id;
2959:
2960: update aso_quote_headers_all
2961: set max_version_flag = 'N',
2962: quote_version = l_old_header_rec.quote_version,
2963: last_update_date = sysdate,
2964: last_updated_by = fnd_global.user_id,

Line 2968: update aso_quote_headers_all

2964: last_updated_by = fnd_global.user_id,
2965: last_update_login = fnd_global.conc_login_id
2966: where quote_header_id = x_quote_header_id;
2967:
2968: update aso_quote_headers_all
2969: set quote_version = l_quote_version,
2970: last_update_date = sysdate,
2971: last_updated_by = fnd_global.user_id,
2972: last_update_login = fnd_global.conc_login_id

Line 4669: FROM ASO_QUOTE_HEADERS_ALL head,

4665:
4666: Cursor C_Get_quote(c_QUOTE_LINE_ID Number) IS
4667: SELECT head.LAST_UPDATE_DATE, head.QUOTE_STATUS_ID, head.QUOTE_NUMBER,
4668: head.TOTAL_ADJUSTED_PERCENT,head.quote_expiration_date
4669: FROM ASO_QUOTE_HEADERS_ALL head,
4670: ASO_QUOTE_LINES_ALL line
4671: WHERE head.QUOTE_HEADER_ID = line.QUOTE_HEADER_ID
4672: AND line.QUOTE_LINE_ID = c_QUOTE_LINE_ID;
4673:

Line 4680: FROM ASO_QUOTE_HEADERS_ALL

4676: WHERE quote_status_id = c_qte_status_id;
4677:
4678: CURSOR C_Qte_Version (X_qte_number NUMBER) IS
4679: SELECT max(quote_version)
4680: FROM ASO_QUOTE_HEADERS_ALL
4681: WHERE quote_number = X_qte_number;
4682:
4683: CURSOR C_Inst_Details (X_shipment_id NUMBER) IS
4684: SELECT sum(customer_product_quantity) FROM cs_line_inst_details

Line 4702: FROM ASO_QUOTE_HEADERS_ALL

4698: WHERE quote_line_id = l_quote_line_id;
4699:
4700: CURSOR get_cust_acct(cust_QUOTE_HEADER_ID Number) IS
4701: SELECT CUST_ACCOUNT_ID
4702: FROM ASO_QUOTE_HEADERS_ALL
4703: WHERE QUOTE_HEADER_ID = cust_QUOTE_HEADER_ID;
4704:
4705: Cursor C_exp_date(c_QUOTE_HEADER_ID Number) IS
4706: Select quote_expiration_date

Line 4707: From ASO_QUOTE_HEADERS_ALL

4703: WHERE QUOTE_HEADER_ID = cust_QUOTE_HEADER_ID;
4704:
4705: Cursor C_exp_date(c_QUOTE_HEADER_ID Number) IS
4706: Select quote_expiration_date
4707: From ASO_QUOTE_HEADERS_ALL
4708: Where QUOTE_HEADER_ID = c_QUOTE_HEADER_ID;
4709:
4710: CURSOR C_org_id IS
4711: SELECT org_id

Line 5112: update aso_quote_headers_all

5108: aso_debug_pub.add('After copy_quote x_quote_header_id: ' || x_quote_header_id);
5109: aso_debug_pub.add('After copy_quote l_qte_nbr: ' || l_qte_nbr);
5110: end if;
5111:
5112: update aso_quote_headers_all
5113: set quote_version = l_quote_version + 1,
5114: max_version_flag = 'Y',
5115: last_update_date = sysdate,
5116: last_updated_by = fnd_global.user_id,

Line 5120: update aso_quote_headers_all

5116: last_updated_by = fnd_global.user_id,
5117: last_update_login = fnd_global.conc_login_id
5118: where quote_header_id = p_qte_line_rec.quote_header_id;
5119:
5120: update aso_quote_headers_all
5121: set max_version_flag = 'N',
5122: quote_version = l_old_header_rec.quote_version,
5123: last_update_date = sysdate,
5124: last_updated_by = fnd_global.user_id,

Line 5128: update aso_quote_headers_all

5124: last_updated_by = fnd_global.user_id,
5125: last_update_login = fnd_global.conc_login_id
5126: where quote_header_id = x_quote_header_id;
5127:
5128: update aso_quote_headers_all
5129: set quote_version = l_quote_version,
5130: last_update_date = sysdate,
5131: last_updated_by = fnd_global.user_id,
5132: last_update_login = fnd_global.conc_login_id

Line 9100: From ASO_QUOTE_HEADERS_ALL head,

9096: IS
9097: Cursor C_Get_quote(c_QUOTE_LINE_ID Number) IS
9098: Select head.LAST_UPDATE_DATE, head.QUOTE_STATUS_ID, head.QUOTE_NUMBER,
9099: head.TOTAL_ADJUSTED_PERCENT, head.quote_header_id
9100: From ASO_QUOTE_HEADERS_ALL head,
9101: ASO_QUOTE_LINES_ALL line
9102: Where head.QUOTE_HEADER_ID = line.QUOTE_HEADER_ID
9103: And line.QUOTE_LINE_ID = c_QUOTE_LINE_ID;
9104:

Line 9111: FROM ASO_QUOTE_HEADERS_ALL

9107: WHERE quote_status_id = c_qte_status_id;
9108:
9109: CURSOR C_Qte_Version (X_qte_number NUMBER) IS
9110: SELECT max(quote_version)
9111: FROM ASO_QUOTE_HEADERS_ALL
9112: WHERE quote_number = X_qte_number;
9113:
9114: CURSOR C_Shipment IS
9115: SELECT shipment_id, reservation_id

Line 9356: update aso_quote_headers_all

9352: aso_debug_pub.add('After copy_quote x_quote_header_id: ' || x_quote_header_id);
9353: aso_debug_pub.add('After copy_quote l_qte_nbr: ' || l_qte_nbr);
9354: end if;
9355:
9356: update aso_quote_headers_all
9357: set quote_version = l_quote_version + 1,
9358: max_version_flag = 'Y',
9359: last_update_date = sysdate,
9360: last_updated_by = fnd_global.user_id,

Line 9364: update aso_quote_headers_all

9360: last_updated_by = fnd_global.user_id,
9361: last_update_login = fnd_global.conc_login_id
9362: where quote_header_id = p_qte_line_rec.quote_header_id;
9363:
9364: update aso_quote_headers_all
9365: set max_version_flag = 'N',
9366: quote_version = l_old_header_rec.quote_version,
9367: last_update_date = sysdate,
9368: last_updated_by = fnd_global.user_id,

Line 9372: update aso_quote_headers_all

9368: last_updated_by = fnd_global.user_id,
9369: last_update_login = fnd_global.conc_login_id
9370: where quote_header_id = x_quote_header_id;
9371:
9372: update aso_quote_headers_all
9373: set quote_version = l_quote_version,
9374: last_update_date = sysdate,
9375: last_updated_by = fnd_global.user_id,
9376: last_update_login = fnd_global.conc_login_id