DBA Data[Home] [Help]

APPS.OE_RETROBILL_PVT dependencies on QP_PREQ_PUB

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

2373: WHERE
2374: LDET.LINE_DETAIL_INDEX = RLTD.LINE_DETAIL_INDEX AND
2375: RLDET.LINE_DETAIL_INDEX = RLTD.RELATED_LINE_DETAIL_INDEX AND
2376: LDET.PRICING_STATUS_CODE = 'N' AND
2377: LDET.PROCESS_CODE IN (QP_PREQ_PUB.G_STATUS_NEW,QP_PREQ_PUB.G_STATUS_UNCHANGED,QP_PREQ_PUB.G_STATUS_UPDATED) AND
2378: nvl(LDET.AUTOMATIC_FLAG, 'N') = 'Y' AND
2379: lDET.CREATED_FROM_LIST_TYPE_CODE NOT IN ('PRL','AGR') AND
2380: lDET.PRICE_ADJUSTMENT_ID IS NOT NULL AND
2381: RLDET.PRICE_ADJUSTMENT_ID IS NOT NULL AND