DBA Data[Home] [Help]

APPS.OE_ADV_PRICE_PVT dependencies on QP_PREQ_RLTD_LINES_TMP

Line 1133: FROM QP_PREQ_RLTD_LINES_TMP RLTD

1129: FND_MESSAGE.SET_NAME('ONT', 'ONT_PRG_INVALID_MASTER_ORG');
1130: SELECT QH.NAME, LDET.LIST_LINE_NO
1131: INTO l_modifier
1132: , l_list_line_no
1133: FROM QP_PREQ_RLTD_LINES_TMP RLTD
1134: ,QP_LDETS_V LDET
1135: , QP_LIST_HEADERS_TL QH
1136: WHERE RLTD.RELATED_LINE_INDEX = p_line_index
1137: AND RLTD.RELATIONSHIP_TYPE_CODE = 'GENERATED_LINE'

Line 1440: FROM qp_preq_rltd_lines_tmp rltd

1436:
1437: BEGIN
1438: SELECT rltd.line_index
1439: INTO l_parent_line_index
1440: FROM qp_preq_rltd_lines_tmp rltd
1441: WHERE rltd.related_line_index = i.line_index
1442: AND relationship_type_code = 'GENERATED_LINE' and rownum=1;
1443:
1444: SELECT line_id

Line 2476: QP_PREQ_RLTD_LINES_TMP RLTD,

2472: ,NULL
2473: ,RLDET.PRICE_ADJUSTMENT_ID
2474: ,1
2475: FROM
2476: QP_PREQ_RLTD_LINES_TMP RLTD,
2477: QP_PREQ_LDETS_TMP LDET,
2478: QP_PREQ_LDETS_TMP RLDET,
2479: QP_PREQ_LINES_TMP RLINE
2480: WHERE