APPS.OE_RMA_QUERY_PRICE dependencies on SO_LINES

Line 55: SELECT SO_LINES.PRICE_LIST_ID

51: P_PRICE_LIST_ID := NULL;
52: P_TERMS_ID := NULL;
53: P_ROUNDING_FACTOR := NULL;
54:
55: SELECT SO_LINES.PRICE_LIST_ID
56: , SO_LINES.TERMS_ID
57: , SOPLS.ROUNDING_FACTOR
58: INTO P_PRICE_LIST_ID
59: , P_TERMS_ID

Line 56: , SO_LINES.TERMS_ID

52: P_TERMS_ID := NULL;
53: P_ROUNDING_FACTOR := NULL;
54:
55: SELECT SO_LINES.PRICE_LIST_ID
56: , SO_LINES.TERMS_ID
57: , SOPLS.ROUNDING_FACTOR
58: INTO P_PRICE_LIST_ID
59: , P_TERMS_ID
60: , P_ROUNDING_FACTOR

Line 62: , SO_LINES

58: INTO P_PRICE_LIST_ID
59: , P_TERMS_ID
60: , P_ROUNDING_FACTOR
61: FROM SO_PRICE_LISTS SOPLS
62: , SO_LINES
63: WHERE SO_LINES.PRICE_LIST_ID = SOPLS.PRICE_LIST_ID
64: AND SO_LINES.LINE_ID = P_LINE_ID;
65:
66: EXCEPTION

Line 63: WHERE SO_LINES.PRICE_LIST_ID = SOPLS.PRICE_LIST_ID

59: , P_TERMS_ID
60: , P_ROUNDING_FACTOR
61: FROM SO_PRICE_LISTS SOPLS
62: , SO_LINES
63: WHERE SO_LINES.PRICE_LIST_ID = SOPLS.PRICE_LIST_ID
64: AND SO_LINES.LINE_ID = P_LINE_ID;
65:
66: EXCEPTION
67: WHEN NO_DATA_FOUND THEN

Line 64: AND SO_LINES.LINE_ID = P_LINE_ID;

60: , P_ROUNDING_FACTOR
61: FROM SO_PRICE_LISTS SOPLS
62: , SO_LINES
63: WHERE SO_LINES.PRICE_LIST_ID = SOPLS.PRICE_LIST_ID
64: AND SO_LINES.LINE_ID = P_LINE_ID;
65:
66: EXCEPTION
67: WHEN NO_DATA_FOUND THEN
68: RETURN;

Line 130: FROM SO_LINES

126: L_PRICING_ATTRIBUTE12,
127: L_PRICING_ATTRIBUTE13,
128: L_PRICING_ATTRIBUTE14,
129: L_PRICING_ATTRIBUTE15
130: FROM SO_LINES
131: WHERE LINE_ID = L_LINK_TO_LINE_ID;
132:
133: RETURN;
134: