DBA Data[Home] [Help]

APPS.IBE_QUOTE_MISC_PVT dependencies on ASO_PRICE_ADJUSTMENTS

Line 963: From ASO_PRICE_ADJUSTMENTS

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);

Line 1149: From ASO_PRICE_ADJUSTMENTS

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);

Line 1335: From ASO_PRICE_ADJUSTMENTS

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

Line 3859: FROM ASO_PRICE_ADJUSTMENTS

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';