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_CHECK_TCA_PVT dependencies on ASO_QUOTE_LINES_ALL

Line 1022: FROM ASO_QUOTE_LINES_ALL

1018: AND sysdate BETWEEN NVL(account_activation_date, sysdate) AND NVL(account_termination_date, sysdate);
1019:
1020: CURSOR C_line_cust IS
1021: SELECT invoice_to_cust_account_id,end_customer_cust_account_id
1022: FROM ASO_QUOTE_LINES_ALL
1023: WHERE quote_line_id = P_Qte_Line_Rec.quote_line_id;
1024:
1025: CURSOR C_ship_cust(l_shipment_id NUMBER) IS
1026: SELECT ship_to_cust_account_id

Line 2627: FROM aso_quote_lines_all a, aso_shipments b

2623: a.End_Customer_cust_account_id, a.End_Customer_cust_party_id,
2624: a.End_Customer_party_id, a.End_Customer_party_site_id,
2625: b.ship_to_cust_account_id, b.ship_to_cust_party_id, b.shipment_id,
2626: b.ship_to_party_id, b.ship_to_party_site_id
2627: FROM aso_quote_lines_all a, aso_shipments b
2628: WHERE a.quote_header_id = qte_hdr
2629: AND a.quote_line_id = b.quote_line_id
2630: AND ((a.invoice_to_cust_account_id IS NULL
2631: AND a.invoice_to_cust_party_id IS NOT NULL)

Line 3054: UPDATE ASO_QUOTE_LINES_ALL

3050: raise FND_API.G_EXC_ERROR;
3051:
3052: ELSE
3053:
3054: UPDATE ASO_QUOTE_LINES_ALL
3055: SET invoice_to_cust_account_id = l_account_id
3056: ,last_update_date = l_last_update_date
3057: ,last_updated_by = l_g_user_id
3058: ,last_update_login = l_g_login_id

Line 3103: UPDATE ASO_QUOTE_LINES_ALL

3099: raise FND_API.G_EXC_ERROR;
3100:
3101: ELSE
3102:
3103: UPDATE ASO_QUOTE_LINES_ALL
3104: SET End_Customer_cust_account_id = l_account_id
3105: ,last_update_date = l_last_update_date
3106: ,last_updated_by = l_g_user_id
3107: ,last_update_login = l_g_login_id

Line 3364: FROM aso_quote_lines_all

3360: AND End_Customer_cust_party_id IS NOT NULL);
3361:
3362: CURSOR C_Get_Line_Acct (qte_hdr NUMBER) IS
3363: SELECT invoice_to_cust_party_id
3364: FROM aso_quote_lines_all
3365: WHERE quote_header_id = qte_hdr
3366: AND invoice_to_cust_account_id IS NULL
3367: AND invoice_to_cust_party_id IS NOT NULL;
3368:

Line 3371: FROM aso_quote_lines_all

3367: AND invoice_to_cust_party_id IS NOT NULL;
3368:
3369: CURSOR C_Get_Line_EndCustAcct (qte_hdr NUMBER) IS
3370: SELECT End_Customer_cust_party_id
3371: FROM aso_quote_lines_all
3372: WHERE quote_header_id = qte_hdr
3373: AND End_Customer_cust_account_id IS NULL
3374: AND End_Customer_cust_party_id IS NOT NULL;
3375: