APPS.OE_PRICE_LIST_PVT dependencies on SO_PRICE_LISTS

Line 195: index(OELST SO_PRICE_LISTS_U1)

191: */
192: -- Fecth driving on item_id
193:
194: SELECT /*+ ordered use_nl(OELST OELIN)
195: index(OELST SO_PRICE_LISTS_U1)
196: index(OELIN SO_PRICE_LIST_LINES_N1) */
197: OELST.ROUNDING_FACTOR
198: , OELIN.METHOD_CODE
199: , OELIN.LIST_PRICE

Line 204: FROM SO_PRICE_LISTS OELST

200: INTO
201: l_rounding_factor
202: , l_prc_method_code_out
203: , l_list_price
204: FROM SO_PRICE_LISTS OELST
205: , SO_PRICE_LIST_LINES OELIN
206: WHERE OELIN.INVENTORY_ITEM_ID = p_inventory_item_id
207: AND OELIN.UNIT_CODE = p_unit_code
208: AND OELIN.METHOD_CODE =

Line 255: index(OELST SO_PRICE_LISTS_U1)

251:
252: -- Fetch driving on p_pricing_attribute2
253:
254: SELECT /*+ ordered use_nl(OELST OELIN)
255: index(OELST SO_PRICE_LISTS_U1)
256: index(OELIN SO_PRICE_LIST_LINES_N1) */
257: OELST.ROUNDING_FACTOR
258: , OELIN.METHOD_CODE
259: , OELIN.LIST_PRICE

Line 264: FROM SO_PRICE_LISTS OELST

260: INTO
261: l_rounding_factor
262: , l_prc_method_code_out
263: , l_list_price
264: FROM SO_PRICE_LISTS OELST
265: , SO_PRICE_LIST_LINES OELIN
266: WHERE OELIN.INVENTORY_ITEM_ID = p_inventory_item_id
267: AND OELIN.UNIT_CODE = p_unit_code
268: AND OELIN.METHOD_CODE =

Line 619: FROM SO_PRICE_LISTS

615: END IF;
616:
617: SELECT SECONDARY_PRICE_LIST_ID
618: INTO l_sec_price_list_id
619: FROM SO_PRICE_LISTS
620: WHERE PRICE_LIST_ID = p_price_list_id;
621:
622: RETURN l_sec_price_list_id;
623:

Line 650: FROM SO_PRICE_LISTS

646: END IF;
647:
648: SELECT NAME
649: INTO l_name
650: FROM SO_PRICE_LISTS
651: WHERE PRICE_LIST_ID = p_price_list_id;
652:
653: RETURN l_name;
654: