APPS.ASO_UTILITY_PVT dependencies on ASO_PRICE_ADJUSTMENTS

Line 865: FROM ASO_PRICE_ADJUSTMENTS

861: QUOTE_SHIPMENT_ID,
862: OPERAND_PER_PQTY,
863: ADJUSTED_AMOUNT_PER_PQTY,
864: OBJECT_VERSION_NUMBER
865: FROM ASO_PRICE_ADJUSTMENTS
866: WHERE quote_header_id = p_qte_header_id
867: AND quote_line_id IS NULL;
868:
869: CURSOR c_price_adj_line IS

Line 964: FROM ASO_PRICE_ADJUSTMENTS

960: QUOTE_SHIPMENT_ID,
961: OPERAND_PER_PQTY,
962: ADJUSTED_AMOUNT_PER_PQTY,
963: OBJECT_VERSION_NUMBER
964: FROM ASO_PRICE_ADJUSTMENTS
965: WHERE quote_header_id = p_qte_header_id
966: AND quote_line_id IS NOT NULL
967: AND quote_line_id = p_qte_line_id;
968:

Line 1269: FROM ASO_PRICE_ADJUSTMENTS

1265: QUOTE_SHIPMENT_ID,
1266: OPERAND_PER_PQTY,
1267: ADJUSTED_AMOUNT_PER_PQTY,
1268: OBJECT_VERSION_NUMBER
1269: FROM ASO_PRICE_ADJUSTMENTS
1270: WHERE quote_header_id = p_qte_header_id
1271: AND quote_line_id IS NULL;
1272:
1273: CURSOR c_price_adj_line IS

Line 1368: FROM ASO_PRICE_ADJUSTMENTS

1364: QUOTE_SHIPMENT_ID,
1365: OPERAND_PER_PQTY,
1366: ADJUSTED_AMOUNT_PER_PQTY,
1367: OBJECT_VERSION_NUMBER
1368: FROM ASO_PRICE_ADJUSTMENTS
1369: WHERE quote_header_id = p_qte_header_id
1370: AND quote_line_id IS NOT NULL
1371: AND quote_line_id = p_qte_line_id
1372: AND modifier_line_type_code <> 'PRG';

Line 1673: FROM ASO_PRICE_ADJUSTMENTS

1669: LIST_HEADER_ID,
1670: LIST_LINE_ID,
1671: QUOTE_SHIPMENT_ID,
1672: OBJECT_VERSION_NUMBER
1673: FROM ASO_PRICE_ADJUSTMENTS
1674: WHERE quote_header_id = p_qte_header_id AND
1675: (quote_line_id = p_qte_line_id OR
1676: (quote_line_id IS NULL AND p_qte_line_id IS NULL))
1677: AND modifier_line_type_code <> 'PRG';