DBA Data[Home] [Help]

APPS.OE_ADV_PRICE_PVT dependencies on QP_LIST_HEADERS_TL

Line 1010: l_modifier QP_LIST_HEADERS_TL.NAME%TYPE;

1006: --
1007: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1008: --
1009: l_org ORG_ORGANIZATION_DEFINITIONS.ORGANIZATION_NAME%TYPE;
1010: l_modifier QP_LIST_HEADERS_TL.NAME%TYPE;
1011: l_list_line_no QP_LIST_LINES.LIST_LINE_NO%TYPE;
1012: Begin
1013: IF l_debug_level > 0 THEN
1014: oe_debug_pub.add( 'SET PRG'||L_LINE_REC.OPERATION||' qty'||p_line_quantity ) ;

Line 1135: , QP_LIST_HEADERS_TL QH

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