APPS.ASO_CHECK_TCA_PVT dependencies on ASO_QUOTE_HEADERS_ALL

Line 437: FROM aso_quote_headers_all

433: AND site_use_type = 'SOLD_TO';
434:
435: CURSOR c_get_cust_account_id IS
436: SELECT invoice_to_cust_account_id
437: FROM aso_quote_headers_all
438: WHERE Quote_header_id = P_Qte_Rec.quote_header_id;
439:
440:
441: l_api_version CONSTANT NUMBER := 1.0;

Line 1010: FROM ASO_QUOTE_HEADERS_ALL

1006: where site_use_id = l_site_use_id;
1007:
1008: CURSOR C_Get_Sold_To_Info(qte_hdr NUMBER) IS
1009: SELECT cust_account_id, cust_party_id
1010: FROM ASO_QUOTE_HEADERS_ALL
1011: WHERE quote_header_id = qte_hdr;
1012:
1013: CURSOR C_Get_Party_From_Acct(acct_id NUMBER) IS
1014: SELECT party_id

Line 2602: FROM aso_quote_headers_all

2598: IS
2599:
2600: CURSOR C_Validate_Quote (qte_hdr NUMBER) IS
2601: SELECT 'X'
2602: FROM aso_quote_headers_all
2603: WHERE quote_header_id = qte_hdr;
2604:
2605: CURSOR C_Get_Hdr_Acct(qte_hdr NUMBER) IS
2606: SELECT a.cust_account_id, a.invoice_to_cust_account_id, a.cust_party_id,

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 2783: UPDATE ASO_QUOTE_HEADERS_ALL

2779: raise FND_API.G_EXC_ERROR;
2780:
2781: ELSE
2782:
2783: UPDATE ASO_QUOTE_HEADERS_ALL
2784: SET cust_account_id = l_account_id
2785: ,last_update_date = l_last_update_date
2786: ,last_updated_by = l_g_user_id
2787: ,last_update_login = l_g_login_id

Line 2834: UPDATE ASO_QUOTE_HEADERS_ALL

2830: raise FND_API.G_EXC_ERROR;
2831:
2832: ELSE
2833:
2834: UPDATE ASO_QUOTE_HEADERS_ALL
2835: SET invoice_to_cust_account_id = l_account_id
2836: ,last_update_date = l_last_update_date
2837: ,last_updated_by = l_g_user_id
2838: ,last_update_login = l_g_login_id

Line 2885: UPDATE ASO_QUOTE_HEADERS_ALL

2881: raise FND_API.G_EXC_ERROR;
2882:
2883: ELSE
2884:
2885: UPDATE ASO_QUOTE_HEADERS_ALL
2886: SET end_customer_cust_account_id = l_account_id
2887: ,last_update_date = l_last_update_date
2888: ,last_updated_by = l_g_user_id
2889: ,last_update_login = l_g_login_id

Line 3338: FROM aso_quote_headers_all

3334: IS
3335:
3336: CURSOR C_Validate_Quote (qte_hdr NUMBER) IS
3337: SELECT 'X'
3338: FROM aso_quote_headers_all
3339: WHERE quote_header_id = qte_hdr;
3340:
3341: CURSOR C_Get_Hdr_CustAcct (qte_hdr NUMBER) IS
3342: SELECT cust_party_id

Line 3343: FROM aso_quote_headers_all

3339: WHERE quote_header_id = qte_hdr;
3340:
3341: CURSOR C_Get_Hdr_CustAcct (qte_hdr NUMBER) IS
3342: SELECT cust_party_id
3343: FROM aso_quote_headers_all
3344: WHERE quote_header_id = qte_hdr
3345: AND (cust_account_id IS NULL
3346: AND cust_party_id IS NOT NULL);
3347:

Line 3350: FROM aso_quote_headers_all

3346: AND cust_party_id IS NOT NULL);
3347:
3348: CURSOR C_Get_Hdr_InvCustAcct (qte_hdr NUMBER) IS
3349: SELECT invoice_to_cust_party_id
3350: FROM aso_quote_headers_all
3351: WHERE quote_header_id = qte_hdr
3352: AND (invoice_to_cust_account_id IS NULL
3353: AND invoice_to_cust_party_id IS NOT NULL);
3354:

Line 3357: FROM aso_quote_headers_all

3353: AND invoice_to_cust_party_id IS NOT NULL);
3354:
3355: CURSOR C_Get_Hdr_EndCustAcct (qte_hdr NUMBER) IS
3356: SELECT End_Customer_cust_party_id
3357: FROM aso_quote_headers_all
3358: WHERE quote_header_id = qte_hdr
3359: AND (End_Customer_cust_account_id IS NULL
3360: AND End_Customer_cust_party_id IS NOT NULL);
3361: