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_SHIPMENTS

Line 1027: FROM ASO_SHIPMENTS

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
1027: FROM ASO_SHIPMENTS
1028: WHERE shipment_id = l_shipment_id;
1029:
1030:
1031:

Line 2614: FROM aso_quote_headers_all a, aso_shipments b

2610: a.End_Customer_cust_party_id, a.End_Customer_cust_account_id,
2611: b.ship_to_party_id, b.ship_to_party_site_id,
2612: b.ship_to_cust_party_id, b.ship_to_cust_account_id,
2613: b.shipment_id
2614: FROM aso_quote_headers_all a, aso_shipments b
2615: WHERE a.quote_header_id = qte_hdr
2616: AND a.quote_header_id = b.quote_header_id
2617: AND b.quote_line_id is NULL;
2618:

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 2936: UPDATE ASO_SHIPMENTS

2932: end if;
2933: raise FND_API.G_EXC_ERROR;
2934:
2935: ELSE
2936: UPDATE ASO_SHIPMENTS
2937: SET ship_to_cust_account_id = l_account_id
2938: ,last_update_date = l_last_update_date
2939: ,last_updated_by = l_g_user_id
2940: ,last_update_login = l_g_login_id

Line 3152: UPDATE ASO_SHIPMENTS

3148: raise FND_API.G_EXC_ERROR;
3149:
3150: ELSE
3151:
3152: UPDATE ASO_SHIPMENTS
3153: SET ship_to_cust_account_id = l_account_id
3154: ,last_update_date = l_last_update_date
3155: ,last_updated_by = l_g_user_id
3156: ,last_update_login = l_g_login_id

Line 3378: FROM aso_shipments

3374: AND End_Customer_cust_party_id IS NOT NULL;
3375:
3376: CURSOR C_Get_Ship_Acct (qte_hdr NUMBER) IS
3377: SELECT ship_to_cust_party_id
3378: FROM aso_shipments
3379: WHERE quote_header_id = qte_hdr
3380: AND ship_to_cust_account_id IS NULL
3381: AND ship_to_cust_party_id IS NOT NULL;
3382: