APPS.OE_ADV_PRICE_PVT dependencies on QP_LIST_HEADERS

Line 618: , QP_LIST_HEADERS_B QH

614: , NULL
615: , 1
616: FROM
617: QP_LDETS_v ldets
618: , QP_LIST_HEADERS_B QH
619: WHERE
620: ldets.line_detail_index = i.line_detail_index
621: and ldets.list_header_id=qh.list_header_id
622: AND ldets.process_code=QP_PREQ_GRP.G_STATUS_NEW

Line 1253: , QP_LIST_HEADERS_B QH

1249: , NULL
1250: , 1
1251: FROM
1252: QP_LDETS_v ldets
1253: , QP_LIST_HEADERS_B QH
1254: WHERE
1255: ldets.line_detail_index = i.line_detail_index
1256: and ldets.list_header_id=qh.list_header_id
1257: AND ldets.process_code=QP_PREQ_GRP.G_STATUS_NEW

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;

Line 2227: qp_list_headers qh,

2223: END IF;
2224: begin
2225: select 1 into l_source_system_code from
2226: oe_order_headers_all oh,
2227: qp_list_headers qh,
2228: -- qp_preq_lines_tmp lines,
2229: qp_preq_ldets_tmp ldets
2230: where qh.currency_code = oh.transactional_curr_code
2231: and oh.header_id = l_header_id

Line 2279: , QP_LIST_HEADERS_B QH

2275: proration_type_code, include_on_returns_flag,lines.line_index line_index
2276: from
2277: QP_LDETS_v ldets
2278: , QP_PREQ_LINES_TMP lines
2279: , QP_LIST_HEADERS_B QH
2280: where
2281: ldets.LIST_HEADER_ID = qh.list_header_id
2282: AND ldets.process_code IN (QP_PREQ_GRP.G_STATUS_NEW,QP_PREQ_GRP.G_STATUS_UPDATED,QP_PREQ_GRP.G_STATUS_UNCHANGED) --Bug8467307
2283: AND lines.pricing_status_code in (QP_PREQ_GRP.G_STATUS_NEW,QP_PREQ_GRP.G_STATUS_UPDATED,QP_PREQ_GRP.G_STATUS_GSA_VIOLATION)

Line 2889: , QP_LIST_HEADERS_B QH

2885: , 1
2886: FROM
2887: QP_LDETS_v ldets
2888: , QP_PREQ_LINES_TMP lines
2889: , QP_LIST_HEADERS_B QH
2890: WHERE
2891: ldets.list_header_id=qh.list_header_id
2892: AND ldets.process_code=QP_PREQ_GRP.G_STATUS_NEW
2893: AND lines.pricing_status_code in (QP_PREQ_GRP.G_STATUS_NEW,QP_PREQ_GRP.G_STATUS_UPDATED,QP_PREQ_GRP.G_STATUS_GSA_VIOLATION)