DBA Data[Home] [Help]

APPS.OE_ORDER_PRICE_PVT dependencies on QP_PREQ_RLTD_LINES_TMP

Line 1934: INSERT INTO QP_PREQ_RLTD_LINES_TMP

1930: oe_debug_pub.add('QP_PREQ_GRP.INSERT_RLTD_LINES2 has reported errors:'||SQLERRM);
1931: RAISE FND_API.G_EXC_ERROR;
1932: END IF;
1933: ELSE --lower than 110510
1934: INSERT INTO QP_PREQ_RLTD_LINES_TMP
1935: (LINE_INDEX,
1936: LINE_DETAIL_INDEX,
1937: RELATIONSHIP_TYPE_CODE,
1938: RELATED_LINE_INDEX,

Line 4521: FROM QP_PREQ_RLTD_LINES_TMP RLTD ,

4517: ,OE_PRICE_ADJ_ASSOCS_S.nextval
4518: ,ADJ.LINE_ID
4519: ,RADJ.PRICE_ADJUSTMENT_ID
4520: ,1
4521: FROM QP_PREQ_RLTD_LINES_TMP RLTD ,
4522: OE_PRICE_ADJUSTMENTS ADJ,
4523: OE_PRICE_ADJUSTMENTS RADJ,
4524: QP_PREQ_LINES_TMP QPL
4525: WHERE

Line 4568: QP_PREQ_RLTD_LINES_TMP RLTD,

4564: ,ADJ.LINE_ID
4565: ,RADJ.PRICE_ADJUSTMENT_ID
4566: ,1
4567: FROM
4568: QP_PREQ_RLTD_LINES_TMP RLTD,
4569: QP_PREQ_LINES_TMP QPL,
4570: OE_PRICE_ADJUSTMENTS ADJ,
4571: OE_PRICE_ADJUSTMENTS RADJ
4572: WHERE QPL.LINE_INDEX = RLTD.LINE_INDEX AND

Line 5975: --DELETE FROM QP_PREQ_RLTD_LINES_TMP;

5971: --DELETE FROM QP_PREQ_LINES_TMP;
5972: --DELETE FROM QP_PREQ_LINE_ATTRS_TMP;
5973: --DELETE FROM QP_PREQ_LDETS_TMP;
5974: --DELETE FROM QP_PREQ_QUAL_TMP;
5975: --DELETE FROM QP_PREQ_RLTD_LINES_TMP;
5976:
5977: G_STMT_NO := 'calculate_adjustments#10';
5978:
5979: