DBA Data[Home] [Help]

APPS.QP_PREQ_PUB dependencies on QP_NUMBER

Line 391: , decode(l_price_phase_flag, G_YES, qp_number.number_to_canonical(nvl(LINE_QUANTITY, 0)), G_NO, qp_number.number_to_canonical(NVL(nvl(PRICED_QUANTITY, LINE_QUANTITY), 0)), 0)

387: , NULL
388: , NULL
389: , G_PRIC_VOLUME_CONTEXT
390: , G_QUANTITY_ATTRIBUTE
391: , decode(l_price_phase_flag, G_YES, qp_number.number_to_canonical(nvl(LINE_QUANTITY, 0)), G_NO, qp_number.number_to_canonical(NVL(nvl(PRICED_QUANTITY, LINE_QUANTITY), 0)), 0)
392: , NULL
393: , NULL
394: , NULL
395: FROM qp_npreq_lines_tmp;

Line 483: , decode(l_price_phase_flag, G_YES, qp_number.number_to_canonical(nvl(LINE_QUANTITY * UNIT_PRICE, 0)), G_NO, qp_number.number_to_canonical(NVL(nvl(PRICED_QUANTITY, LINE_QUANTITY), 0) * nvl(UNIT_PRICE, 0)), 0)

479: , NULL
480: , NULL
481: , G_PRIC_VOLUME_CONTEXT
482: , G_LINE_AMT_ATTRIBUTE
483: , decode(l_price_phase_flag, G_YES, qp_number.number_to_canonical(nvl(LINE_QUANTITY * UNIT_PRICE, 0)), G_NO, qp_number.number_to_canonical(NVL(nvl(PRICED_QUANTITY, LINE_QUANTITY), 0) * nvl(UNIT_PRICE, 0)), 0)
484: , NULL
485: , NULL
486: , NULL
487: FROM qp_npreq_lines_tmp;