DBA Data[Home] [Help]

APPS.OE_ADV_PRICE_PVT dependencies on QP_PREQ_RLTD_LINES_TMP

Line 1430: FROM QP_PREQ_RLTD_LINES_TMP RLTD

1426: FND_MESSAGE.SET_NAME('ONT', 'ONT_PRG_INVALID_MASTER_ORG');
1427: SELECT QH.NAME, LDET.LIST_LINE_NO
1428: INTO l_modifier
1429: , l_list_line_no
1430: FROM QP_PREQ_RLTD_LINES_TMP RLTD
1431: ,QP_LDETS_V LDET
1432: , QP_LIST_HEADERS_TL QH
1433: WHERE RLTD.RELATED_LINE_INDEX = p_line_index
1434: AND RLTD.RELATIONSHIP_TYPE_CODE = 'GENERATED_LINE'

Line 1813: FROM qp_preq_rltd_lines_tmp rltd

1809:
1810: BEGIN
1811: SELECT rltd.line_index
1812: INTO l_parent_line_index
1813: FROM qp_preq_rltd_lines_tmp rltd
1814: WHERE rltd.related_line_index = i.line_index
1815: AND relationship_type_code = 'GENERATED_LINE' and rownum=1;
1816:
1817: SELECT line_id

Line 2949: QP_PREQ_RLTD_LINES_TMP RLTD,

2945: ,NULL
2946: ,RLDET.PRICE_ADJUSTMENT_ID
2947: ,1
2948: FROM
2949: QP_PREQ_RLTD_LINES_TMP RLTD,
2950: QP_PREQ_LDETS_TMP LDET,
2951: QP_PREQ_LDETS_TMP RLDET,
2952: QP_PREQ_LINES_TMP RLINE
2953: WHERE