DBA Data[Home] [Help]

APPS.OE_ADV_PRICE_PVT dependencies on QP_LIST_HEADERS_TL

Line 1297: l_modifier QP_LIST_HEADERS_TL.NAME%TYPE;

1293: --
1294: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1295: --
1296: l_org ORG_ORGANIZATION_DEFINITIONS.ORGANIZATION_NAME%TYPE;
1297: l_modifier QP_LIST_HEADERS_TL.NAME%TYPE;
1298: l_list_line_no QP_LIST_LINES.LIST_LINE_NO%TYPE;
1299: Begin
1300: IF l_debug_level > 0 THEN
1301: oe_debug_pub.add( 'SET PRG'||L_LINE_REC.OPERATION||' qty'||p_line_quantity ) ;

Line 1432: , QP_LIST_HEADERS_TL QH

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'
1435: AND RLTD.LINE_DETAIL_INDEX = LDET.LINE_DETAIL_INDEX
1436: AND LDET.LIST_HEADER_ID = QH.LIST_HEADER_ID AND ROWNUM=1;