DBA Data[Home] [Help]

APPS.PO_VAL_PRICE_DIFFS dependencies on PO_PRICE_DIFFERENTIALS

Line 315: PO_PRICE_DIFFERENTIALS SRC_PRICE_DIFF

311: p_entity_type_tbl(i) = c_PO_LINE
312: AND EXISTS
313: ( SELECT null
314: FROM
315: PO_PRICE_DIFFERENTIALS SRC_PRICE_DIFF
316: WHERE
317: SRC_PRICE_DIFF.entity_id =
318: NVL(p_from_line_location_id_tbl(i),p_from_line_id_tbl(i))
319: AND SRC_PRICE_DIFF.entity_type =

Line 407: FROM PO_PRICE_DIFFERENTIALS SRC_PRICE_DIFF

403: , c_MIN
404: , SRC_PRICE_DIFF.min_multiplier
405: , c_MAX
406: , SRC_PRICE_DIFF.max_multiplier
407: FROM PO_PRICE_DIFFERENTIALS SRC_PRICE_DIFF
408: WHERE
409: p_entity_type_tbl(i) = c_PO_LINE
410: AND
411: SRC_PRICE_DIFF.entity_id =

Line 500: FROM PO_PRICE_DIFFERENTIALS SRC_PRICE_DIFF

496: , PO_MESSAGE_S.PO_SVC_MULTIPLIER_GT_MIN
497: -- Removed the EXISTS statement from the WHERE clause
498: , c_MIN
499: , SRC_PRICE_DIFF.min_multiplier
500: FROM PO_PRICE_DIFFERENTIALS SRC_PRICE_DIFF
501: WHERE
502: p_entity_type_tbl(i) = c_PO_LINE
503: AND SRC_PRICE_DIFF.entity_id =
504: NVL(p_from_line_location_id_tbl(i),p_from_line_id_tbl(i))