959: ,SUBSTITUTION_ATTRIBUTE
960: ,PRORATION_TYPE_CODE
961: ,INCLUDE_ON_RETURNS_FLAG
962: ,CREDIT_OR_CHARGE_FLAG
963: From ASO_PRICE_ADJUSTMENTS
964: Where QUOTE_LINE_ID = p_quote_line_id;
965:
966: begin
967: open c_getLinePrcAdjTbl(p_quote_line_id);
1145: ,SUBSTITUTION_ATTRIBUTE
1146: ,PRORATION_TYPE_CODE
1147: ,INCLUDE_ON_RETURNS_FLAG
1148: ,CREDIT_OR_CHARGE_FLAG
1149: From ASO_PRICE_ADJUSTMENTS
1150: Where QUOTE_HEADER_ID = p_quote_hdr_id;
1151:
1152: begin
1153: open c_getHdrPrcAdjTbl(p_quote_hdr_id);
1331: ,SUBSTITUTION_ATTRIBUTE
1332: ,PRORATION_TYPE_CODE
1333: ,INCLUDE_ON_RETURNS_FLAG
1334: ,CREDIT_OR_CHARGE_FLAG
1335: From ASO_PRICE_ADJUSTMENTS
1336: Where QUOTE_HEADER_ID = p_quote_hdr_id
1337: and QUOTE_LINE_ID is not null;
1338:
1339: begin
3855: CHANGE_SEQUENCE,
3856: LIST_HEADER_ID,
3857: LIST_LINE_ID,
3858: QUOTE_SHIPMENT_ID
3859: FROM ASO_PRICE_ADJUSTMENTS
3860: WHERE quote_header_id = p_qte_header_id AND
3861: (quote_line_id = p_qte_line_id OR
3862: (quote_line_id IS NULL AND p_qte_line_id IS NULL))
3863: AND modifier_line_type_code <> 'PRG';