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 2568: FROM aso_quote_headers_all

2564: IS
2565:
2566: CURSOR C_Validate_Quote (qte_hdr NUMBER) IS
2567: SELECT 'X'
2568: FROM aso_quote_headers_all
2569: WHERE quote_header_id = qte_hdr;
2570:
2571: CURSOR C_Get_Hdr_Acct(qte_hdr NUMBER) IS
2572: SELECT a.cust_account_id, a.invoice_to_cust_account_id, a.cust_party_id,

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

2743: raise FND_API.G_EXC_ERROR;
2744:
2745: ELSE
2746:
2747: UPDATE ASO_QUOTE_HEADERS_ALL
2748: SET cust_account_id = l_account_id
2749: ,last_update_date = l_last_update_date
2750: ,last_updated_by = l_g_user_id
2751: ,last_update_login = l_g_login_id

Line 2796: UPDATE ASO_QUOTE_HEADERS_ALL

2792: raise FND_API.G_EXC_ERROR;
2793:
2794: ELSE
2795:
2796: UPDATE ASO_QUOTE_HEADERS_ALL
2797: SET invoice_to_cust_account_id = l_account_id
2798: ,last_update_date = l_last_update_date
2799: ,last_updated_by = l_g_user_id
2800: ,last_update_login = l_g_login_id

Line 2845: UPDATE ASO_QUOTE_HEADERS_ALL

2841: raise FND_API.G_EXC_ERROR;
2842:
2843: ELSE
2844:
2845: UPDATE ASO_QUOTE_HEADERS_ALL
2846: SET end_customer_cust_account_id = l_account_id
2847: ,last_update_date = l_last_update_date
2848: ,last_updated_by = l_g_user_id
2849: ,last_update_login = l_g_login_id

Line 3290: FROM aso_quote_headers_all

3286: IS
3287:
3288: CURSOR C_Validate_Quote (qte_hdr NUMBER) IS
3289: SELECT 'X'
3290: FROM aso_quote_headers_all
3291: WHERE quote_header_id = qte_hdr;
3292:
3293: CURSOR C_Get_Hdr_CustAcct (qte_hdr NUMBER) IS
3294: SELECT cust_party_id

Line 3295: FROM aso_quote_headers_all

3291: WHERE quote_header_id = qte_hdr;
3292:
3293: CURSOR C_Get_Hdr_CustAcct (qte_hdr NUMBER) IS
3294: SELECT cust_party_id
3295: FROM aso_quote_headers_all
3296: WHERE quote_header_id = qte_hdr
3297: AND (cust_account_id IS NULL
3298: AND cust_party_id IS NOT NULL);
3299:

Line 3302: FROM aso_quote_headers_all

3298: AND cust_party_id IS NOT NULL);
3299:
3300: CURSOR C_Get_Hdr_InvCustAcct (qte_hdr NUMBER) IS
3301: SELECT invoice_to_cust_party_id
3302: FROM aso_quote_headers_all
3303: WHERE quote_header_id = qte_hdr
3304: AND (invoice_to_cust_account_id IS NULL
3305: AND invoice_to_cust_party_id IS NOT NULL);
3306:

Line 3309: FROM aso_quote_headers_all

3305: AND invoice_to_cust_party_id IS NOT NULL);
3306:
3307: CURSOR C_Get_Hdr_EndCustAcct (qte_hdr NUMBER) IS
3308: SELECT End_Customer_cust_party_id
3309: FROM aso_quote_headers_all
3310: WHERE quote_header_id = qte_hdr
3311: AND (End_Customer_cust_account_id IS NULL
3312: AND End_Customer_cust_party_id IS NOT NULL);
3313: