DBA Data[Home] [Help]

APPS.ASO_UTILITY_PVT dependencies on ASO_SHIPMENTS

Line 2298: FROM ASO_SHIPMENTS

2294: l_shipment_rec.DEMAND_CLASS_CODE,
2295: l_shipment_rec.OBJECT_VERSION_NUMBER,
2296: l_shipment_rec.SHIP_METHOD_CODE_FROM,
2297: l_shipment_rec.FREIGHT_TERMS_CODE_FROM
2298: FROM ASO_SHIPMENTS
2299: WHERE shipment_id = p_shipment_id;
2300: RETURN l_shipment_rec;
2301: EXCEPTION
2302: WHEN NO_DATA_FOUND THEN

Line 2379: FROM ASO_SHIPMENTS

2375: DEMAND_CLASS_CODE,
2376: OBJECT_VERSION_NUMBER,
2377: SHIP_METHOD_CODE_FROM,
2378: FREIGHT_TERMS_CODE_FROM
2379: FROM ASO_SHIPMENTS
2380: WHERE quote_header_id = p_qte_header_id
2381: AND quote_line_id IS NULL;
2382:
2383: CURSOR c_shipment_line IS

Line 2446: FROM ASO_SHIPMENTS

2442: OBJECT_VERSION_NUMBER,
2443: SHIP_METHOD_CODE_FROM,
2444: FREIGHT_TERMS_CODE_FROM
2445:
2446: FROM ASO_SHIPMENTS
2447: WHERE quote_header_id = p_qte_header_id
2448: AND quote_line_id IS NOT NULL
2449: AND quote_line_id = p_qte_line_id;
2450:

Line 2655: FROM ASO_SHIPMENTS

2651: OBJECT_VERSION_NUMBER,
2652: SHIP_METHOD_CODE_FROM,
2653: FREIGHT_TERMS_CODE_FROM
2654:
2655: FROM ASO_SHIPMENTS
2656: WHERE quote_header_id = p_qte_header_id
2657: AND quote_line_id = p_qte_line_id;
2658:
2659: l_shipment_rec ASO_QUOTE_PUB.Shipment_Rec_Type;