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 4515: FROM aso_quote_headers_all -- bug 8968033

4511: -- Adding the call to insert record in the ASO_CHANGED_QUOTES
4512:
4513: SELECT quote_number
4514: INTO l_quote_number
4515: FROM aso_quote_headers_all -- bug 8968033
4516: WHERE quote_header_id = x_Qte_line_rec.quote_header_id ;
4517:
4518: IF aso_debug_pub.g_debug_flag = 'Y' THEN
4519: aso_debug_pub.add('ASO_QUOTE_LINES_PVT.Create_Quote_lines : Calling ASO_UTILITY_PVT.UPDATE_CHANGED_QUOTES, quote number : ' || l_quote_number, 1, 'Y');

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 5136: update aso_quote_headers_all

5132: aso_debug_pub.add('After copy_quote x_quote_header_id: ' || x_quote_header_id);
5133: aso_debug_pub.add('After copy_quote l_qte_nbr: ' || l_qte_nbr);
5134: end if;
5135:
5136: update aso_quote_headers_all
5137: set quote_version = l_quote_version + 1,
5138: max_version_flag = 'Y',
5139: last_update_date = sysdate,
5140: last_updated_by = fnd_global.user_id,

Line 5144: update aso_quote_headers_all

5140: last_updated_by = fnd_global.user_id,
5141: last_update_login = fnd_global.conc_login_id
5142: where quote_header_id = p_qte_line_rec.quote_header_id;
5143:
5144: update aso_quote_headers_all
5145: set max_version_flag = 'N',
5146: quote_version = l_old_header_rec.quote_version,
5147: last_update_date = sysdate,
5148: last_updated_by = fnd_global.user_id,

Line 5152: update aso_quote_headers_all

5148: last_updated_by = fnd_global.user_id,
5149: last_update_login = fnd_global.conc_login_id
5150: where quote_header_id = x_quote_header_id;
5151:
5152: update aso_quote_headers_all
5153: set quote_version = l_quote_version,
5154: last_update_date = sysdate,
5155: last_updated_by = fnd_global.user_id,
5156: last_update_login = fnd_global.conc_login_id

Line 9106: FROM aso_quote_headers_all -- bug 8968033

9102: -- Adding the call to insert record in the ASO_CHANGED_QUOTES
9103:
9104: SELECT quote_number
9105: INTO l_quote_number
9106: FROM aso_quote_headers_all -- bug 8968033
9107: WHERE quote_header_id = l_Qte_Line_Rec.quote_header_id;
9108:
9109: IF aso_debug_pub.g_debug_flag = 'Y' THEN
9110: aso_debug_pub.add('ASO_QUOTE_LINES_PVT.update_quote_line : Calling ASO_UTILITY_PVT.UPDATE_CHANGED_QUOTES, quote number : ' || l_quote_number, 1, 'Y');

Line 9218: From ASO_QUOTE_HEADERS_ALL head,

9214: IS
9215: Cursor C_Get_quote(c_QUOTE_LINE_ID Number) IS
9216: Select head.LAST_UPDATE_DATE, head.QUOTE_STATUS_ID, head.QUOTE_NUMBER,
9217: head.TOTAL_ADJUSTED_PERCENT, head.quote_header_id
9218: From ASO_QUOTE_HEADERS_ALL head,
9219: ASO_QUOTE_LINES_ALL line
9220: Where head.QUOTE_HEADER_ID = line.QUOTE_HEADER_ID
9221: And line.QUOTE_LINE_ID = c_QUOTE_LINE_ID;
9222:

Line 9229: FROM ASO_QUOTE_HEADERS_ALL

9225: WHERE quote_status_id = c_qte_status_id;
9226:
9227: CURSOR C_Qte_Version (X_qte_number NUMBER) IS
9228: SELECT max(quote_version)
9229: FROM ASO_QUOTE_HEADERS_ALL
9230: WHERE quote_number = X_qte_number;
9231:
9232: CURSOR C_Shipment IS
9233: SELECT shipment_id, reservation_id

Line 9281: FROM aso_quote_headers_all -- bug 8968033

9277: and a.quote_line_id <> p_qte_line_rec.quote_line_id;
9278:
9279: cursor get_qte_nbr(qte_hdr_id number) is
9280: SELECT quote_number
9281: FROM aso_quote_headers_all -- bug 8968033
9282: WHERE quote_header_id = qte_hdr_id;
9283:
9284: l_api_name CONSTANT VARCHAR2(30) := 'Delete_quote_line';
9285: l_api_version_number CONSTANT NUMBER := 1.0;

Line 9474: update aso_quote_headers_all

9470: aso_debug_pub.add('After copy_quote x_quote_header_id: ' || x_quote_header_id);
9471: aso_debug_pub.add('After copy_quote l_qte_nbr: ' || l_qte_nbr);
9472: end if;
9473:
9474: update aso_quote_headers_all
9475: set quote_version = l_quote_version + 1,
9476: max_version_flag = 'Y',
9477: last_update_date = sysdate,
9478: last_updated_by = fnd_global.user_id,

Line 9482: update aso_quote_headers_all

9478: last_updated_by = fnd_global.user_id,
9479: last_update_login = fnd_global.conc_login_id
9480: where quote_header_id = p_qte_line_rec.quote_header_id;
9481:
9482: update aso_quote_headers_all
9483: set max_version_flag = 'N',
9484: quote_version = l_old_header_rec.quote_version,
9485: last_update_date = sysdate,
9486: last_updated_by = fnd_global.user_id,

Line 9490: update aso_quote_headers_all

9486: last_updated_by = fnd_global.user_id,
9487: last_update_login = fnd_global.conc_login_id
9488: where quote_header_id = x_quote_header_id;
9489:
9490: update aso_quote_headers_all
9491: set quote_version = l_quote_version,
9492: last_update_date = sysdate,
9493: last_updated_by = fnd_global.user_id,
9494: last_update_login = fnd_global.conc_login_id