DBA Data[Home] [Help]

APPS.OE_ORDER_PRICE_PVT dependencies on QP_PREQ_RLTD_LINES_TMP

Line 1935: INSERT INTO QP_PREQ_RLTD_LINES_TMP

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

Line 4636: FROM QP_PREQ_RLTD_LINES_TMP RLTD ,

4632: ,OE_PRICE_ADJ_ASSOCS_S.nextval
4633: ,ADJ.LINE_ID
4634: ,RADJ.PRICE_ADJUSTMENT_ID
4635: ,1
4636: FROM QP_PREQ_RLTD_LINES_TMP RLTD ,
4637: OE_PRICE_ADJUSTMENTS ADJ,
4638: OE_PRICE_ADJUSTMENTS RADJ,
4639: QP_PREQ_LINES_TMP QPL
4640: WHERE

Line 4683: QP_PREQ_RLTD_LINES_TMP RLTD,

4679: ,ADJ.LINE_ID
4680: ,RADJ.PRICE_ADJUSTMENT_ID
4681: ,1
4682: FROM
4683: QP_PREQ_RLTD_LINES_TMP RLTD,
4684: QP_PREQ_LINES_TMP QPL,
4685: OE_PRICE_ADJUSTMENTS ADJ,
4686: OE_PRICE_ADJUSTMENTS RADJ
4687: WHERE QPL.LINE_INDEX = RLTD.LINE_INDEX AND

Line 6258: --DELETE FROM QP_PREQ_RLTD_LINES_TMP;

6254: --DELETE FROM QP_PREQ_LINES_TMP;
6255: --DELETE FROM QP_PREQ_LINE_ATTRS_TMP;
6256: --DELETE FROM QP_PREQ_LDETS_TMP;
6257: --DELETE FROM QP_PREQ_QUAL_TMP;
6258: --DELETE FROM QP_PREQ_RLTD_LINES_TMP;
6259:
6260: G_STMT_NO := 'calculate_adjustments#10';
6261:
6262: