APPS.OE_ADV_PRICE_PVT dependencies on QP_LIST_HEADERS

Line 550: , QP_LIST_HEADERS_B QH

546: , NULL
547: , 1
548: FROM
549: QP_LDETS_v ldets
550: , QP_LIST_HEADERS_B QH
551: WHERE
552: ldets.line_detail_index = i.line_detail_index
553: and ldets.list_header_id=qh.list_header_id
554: AND ldets.process_code=QP_PREQ_GRP.G_STATUS_NEW

Line 968: , QP_LIST_HEADERS_B QH

964: , NULL
965: , 1
966: FROM
967: QP_LDETS_v ldets
968: , QP_LIST_HEADERS_B QH
969: WHERE
970: ldets.line_detail_index = i.line_detail_index
971: and ldets.list_header_id=qh.list_header_id
972: AND ldets.process_code=QP_PREQ_GRP.G_STATUS_NEW

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;

Line 1800: qp_list_headers qh,

1796: END IF;
1797: begin
1798: select 1 into l_source_system_code from
1799: oe_order_headers_all oh,
1800: qp_list_headers qh,
1801: -- qp_preq_lines_tmp lines,
1802: qp_preq_ldets_tmp ldets
1803: where qh.currency_code = oh.transactional_curr_code
1804: and oh.header_id = l_header_id

Line 1852: , QP_LIST_HEADERS_B QH

1848: proration_type_code, include_on_returns_flag,lines.line_index line_index
1849: from
1850: QP_LDETS_v ldets
1851: , QP_PREQ_LINES_TMP lines
1852: , QP_LIST_HEADERS_B QH
1853: where
1854: ldets.LIST_HEADER_ID = qh.list_header_id
1855: AND ldets.process_code IN (QP_PREQ_GRP.G_STATUS_NEW,QP_PREQ_GRP.G_STATUS_UPDATED)
1856: 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 2421: , QP_LIST_HEADERS_B QH

2417: , 1
2418: FROM
2419: QP_LDETS_v ldets
2420: , QP_PREQ_LINES_TMP lines
2421: , QP_LIST_HEADERS_B QH
2422: WHERE
2423: ldets.list_header_id=qh.list_header_id
2424: AND ldets.process_code=QP_PREQ_GRP.G_STATUS_NEW
2425: 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)