eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OE_BULK_PRICEORDER_PVT dependencies on QP_PREQ_PUB

Line 442: LDET.PROCESS_CODE IN (QP_PREQ_PUB.G_STATUS_NEW,QP_PREQ_PUB.G_STATUS_UNCHANGED,QP_PREQ_PUB.G_STATUS_UPDATED) AND

438: WHERE
439: LDET.LINE_DETAIL_INDEX = RLTD.LINE_DETAIL_INDEX AND
440: RLDET.LINE_DETAIL_INDEX = RLTD.RELATED_LINE_DETAIL_INDEX AND
441: LDET.PRICING_STATUS_CODE = 'N' AND
442: LDET.PROCESS_CODE IN (QP_PREQ_PUB.G_STATUS_NEW,QP_PREQ_PUB.G_STATUS_UNCHANGED,QP_PREQ_PUB.G_STATUS_UPDATED) AND
443: nvl(LDET.AUTOMATIC_FLAG, 'N') = 'Y' AND
444: lDET.CREATED_FROM_LIST_TYPE_CODE NOT IN ('PRL','AGR') AND
445: lDET.PRICE_ADJUSTMENT_ID IS NOT NULL AND
446: RLDET.PRICE_ADJUSTMENT_ID IS NOT NULL AND

Line 509: WHERE QPLAT.pricing_status_code=QP_PREQ_PUB.G_STATUS_NEW

505: ,OE_PRICE_ADJ_ATTRIBS_S.nextval
506: ,1
507: FROM QP_PREQ_LINE_ATTRS_TMP QPLAT
508: , QP_LDETS_v LDETS
509: WHERE QPLAT.pricing_status_code=QP_PREQ_PUB.G_STATUS_NEW
510: AND QPLAT.LINE_DETAIL_INDEX = LDETS.LINE_DETAIL_INDEX
511: AND QPLAT.LINE_INDEX = LDETS.LINE_INDEX
512: AND LDETS.PROCESS_CODE=QP_PREQ_PUB.G_STATUS_NEW
513: AND LDETS.AUTOMATIC_FLAG = 'Y'

Line 512: AND LDETS.PROCESS_CODE=QP_PREQ_PUB.G_STATUS_NEW

508: , QP_LDETS_v LDETS
509: WHERE QPLAT.pricing_status_code=QP_PREQ_PUB.G_STATUS_NEW
510: AND QPLAT.LINE_DETAIL_INDEX = LDETS.LINE_DETAIL_INDEX
511: AND QPLAT.LINE_INDEX = LDETS.LINE_INDEX
512: AND LDETS.PROCESS_CODE=QP_PREQ_PUB.G_STATUS_NEW
513: AND LDETS.AUTOMATIC_FLAG = 'Y'
514: AND LDETS.CREATED_FROM_LIST_TYPE_CODE NOT IN ('PRL','AGR')
515: );
516:

Line 1510: oe_debug_pub.add('before QP_PREQ_PUB.PRICE_REQUEST');

1506: -- Selecting hsecs from v$times is changed to execute only when debug
1507: -- is enabled, as hsec is used for logging only when debug is enabled.
1508: SELECT hsecs INTO l_start_time from v$timer;
1509:
1510: oe_debug_pub.add('before QP_PREQ_PUB.PRICE_REQUEST');
1511: end if;
1512: QP_PREQ_PUB.PRICE_REQUEST
1513: (p_control_rec => l_Price_Control_rec
1514: ,x_return_status =>x_return_status

Line 1512: QP_PREQ_PUB.PRICE_REQUEST

1508: SELECT hsecs INTO l_start_time from v$timer;
1509:
1510: oe_debug_pub.add('before QP_PREQ_PUB.PRICE_REQUEST');
1511: end if;
1512: QP_PREQ_PUB.PRICE_REQUEST
1513: (p_control_rec => l_Price_Control_rec
1514: ,x_return_status =>x_return_status
1515: ,x_return_status_Text =>x_return_status_Text
1516: );