DBA Data[Home] [Help]

APPS.ASO_UTILITY_PVT dependencies on ASO_PRICE_ADJUSTMENTS

Line 856: FROM ASO_PRICE_ADJUSTMENTS

852: QUOTE_SHIPMENT_ID,
853: OPERAND_PER_PQTY,
854: ADJUSTED_AMOUNT_PER_PQTY,
855: OBJECT_VERSION_NUMBER
856: FROM ASO_PRICE_ADJUSTMENTS
857: WHERE quote_header_id = p_qte_header_id
858: AND quote_line_id IS NULL;
859:
860: CURSOR c_price_adj_line IS

Line 955: FROM ASO_PRICE_ADJUSTMENTS

951: QUOTE_SHIPMENT_ID,
952: OPERAND_PER_PQTY,
953: ADJUSTED_AMOUNT_PER_PQTY,
954: OBJECT_VERSION_NUMBER
955: FROM ASO_PRICE_ADJUSTMENTS
956: WHERE quote_header_id = p_qte_header_id
957: AND quote_line_id IS NOT NULL
958: AND quote_line_id = p_qte_line_id;
959:

Line 1260: FROM ASO_PRICE_ADJUSTMENTS

1256: QUOTE_SHIPMENT_ID,
1257: OPERAND_PER_PQTY,
1258: ADJUSTED_AMOUNT_PER_PQTY,
1259: OBJECT_VERSION_NUMBER
1260: FROM ASO_PRICE_ADJUSTMENTS
1261: WHERE quote_header_id = p_qte_header_id
1262: AND quote_line_id IS NULL;
1263:
1264: CURSOR c_price_adj_line IS

Line 1359: FROM ASO_PRICE_ADJUSTMENTS

1355: QUOTE_SHIPMENT_ID,
1356: OPERAND_PER_PQTY,
1357: ADJUSTED_AMOUNT_PER_PQTY,
1358: OBJECT_VERSION_NUMBER
1359: FROM ASO_PRICE_ADJUSTMENTS
1360: WHERE quote_header_id = p_qte_header_id
1361: AND quote_line_id IS NOT NULL
1362: AND quote_line_id = p_qte_line_id
1363: AND modifier_line_type_code <> 'PRG';

Line 1664: FROM ASO_PRICE_ADJUSTMENTS

1660: LIST_HEADER_ID,
1661: LIST_LINE_ID,
1662: QUOTE_SHIPMENT_ID,
1663: OBJECT_VERSION_NUMBER
1664: FROM ASO_PRICE_ADJUSTMENTS
1665: WHERE quote_header_id = p_qte_header_id AND
1666: (quote_line_id = p_qte_line_id OR
1667: (quote_line_id IS NULL AND p_qte_line_id IS NULL))
1668: AND modifier_line_type_code <> 'PRG';