DBA Data[Home] [Help]

APPS.ASO_UTILITY_PVT dependencies on ASO_SHIPMENTS

Line 2307: FROM ASO_SHIPMENTS

2303: l_shipment_rec.DEMAND_CLASS_CODE,
2304: l_shipment_rec.OBJECT_VERSION_NUMBER,
2305: l_shipment_rec.SHIP_METHOD_CODE_FROM,
2306: l_shipment_rec.FREIGHT_TERMS_CODE_FROM
2307: FROM ASO_SHIPMENTS
2308: WHERE shipment_id = p_shipment_id;
2309: RETURN l_shipment_rec;
2310: EXCEPTION
2311: WHEN NO_DATA_FOUND THEN

Line 2388: FROM ASO_SHIPMENTS

2384: DEMAND_CLASS_CODE,
2385: OBJECT_VERSION_NUMBER,
2386: SHIP_METHOD_CODE_FROM,
2387: FREIGHT_TERMS_CODE_FROM
2388: FROM ASO_SHIPMENTS
2389: WHERE quote_header_id = p_qte_header_id
2390: AND quote_line_id IS NULL;
2391:
2392: CURSOR c_shipment_line IS

Line 2455: FROM ASO_SHIPMENTS

2451: OBJECT_VERSION_NUMBER,
2452: SHIP_METHOD_CODE_FROM,
2453: FREIGHT_TERMS_CODE_FROM
2454:
2455: FROM ASO_SHIPMENTS
2456: WHERE quote_header_id = p_qte_header_id
2457: AND quote_line_id IS NOT NULL
2458: AND quote_line_id = p_qte_line_id;
2459:

Line 2664: FROM ASO_SHIPMENTS

2660: OBJECT_VERSION_NUMBER,
2661: SHIP_METHOD_CODE_FROM,
2662: FREIGHT_TERMS_CODE_FROM
2663:
2664: FROM ASO_SHIPMENTS
2665: WHERE quote_header_id = p_qte_header_id
2666: AND quote_line_id = p_qte_line_id;
2667:
2668: l_shipment_rec ASO_QUOTE_PUB.Shipment_Rec_Type;