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 2580: FROM aso_quote_headers_all a, aso_shipments b

2576: a.End_Customer_cust_party_id, a.End_Customer_cust_account_id,
2577: b.ship_to_party_id, b.ship_to_party_site_id,
2578: b.ship_to_cust_party_id, b.ship_to_cust_account_id,
2579: b.shipment_id
2580: FROM aso_quote_headers_all a, aso_shipments b
2581: WHERE a.quote_header_id = qte_hdr
2582: AND a.quote_header_id = b.quote_header_id
2583: AND b.quote_line_id is NULL;
2584:

Line 2593: FROM aso_quote_lines_all a, aso_shipments b

2589: a.End_Customer_cust_account_id, a.End_Customer_cust_party_id,
2590: a.End_Customer_party_id, a.End_Customer_party_site_id,
2591: b.ship_to_cust_account_id, b.ship_to_cust_party_id, b.shipment_id,
2592: b.ship_to_party_id, b.ship_to_party_site_id
2593: FROM aso_quote_lines_all a, aso_shipments b
2594: WHERE a.quote_header_id = qte_hdr
2595: AND a.quote_line_id = b.quote_line_id
2596: AND ((a.invoice_to_cust_account_id IS NULL
2597: AND a.invoice_to_cust_party_id IS NOT NULL)

Line 2894: UPDATE ASO_SHIPMENTS

2890: END IF;
2891: raise FND_API.G_EXC_ERROR;
2892:
2893: ELSE
2894: UPDATE ASO_SHIPMENTS
2895: SET ship_to_cust_account_id = l_account_id
2896: ,last_update_date = l_last_update_date
2897: ,last_updated_by = l_g_user_id
2898: ,last_update_login = l_g_login_id

Line 3104: UPDATE ASO_SHIPMENTS

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

Line 3330: FROM aso_shipments

3326: AND End_Customer_cust_party_id IS NOT NULL;
3327:
3328: CURSOR C_Get_Ship_Acct (qte_hdr NUMBER) IS
3329: SELECT ship_to_cust_party_id
3330: FROM aso_shipments
3331: WHERE quote_header_id = qte_hdr
3332: AND ship_to_cust_account_id IS NULL
3333: AND ship_to_cust_party_id IS NOT NULL;
3334: