APPS.PO_PRICE_ADJUSTMENTS_PKG dependencies on QP_PREQ_LINES_TMP

Line 1321: DELETE FROM QP_PREQ_LINES_TMP_TEST;

1317: /*
1318: IF p_order_header_id = 81699 THEN
1319: DELETE FROM QP_PREQ_RLTD_LINES_TMP_TEST;
1320: DELETE FROM QP_PREQ_LINE_ATTRS_TMP_TEST;
1321: DELETE FROM QP_PREQ_LINES_TMP_TEST;
1322: DELETE FROM QP_PREQ_LDETS_TMP_TEST;
1323:
1324: INSERT INTO QP_PREQ_RLTD_LINES_TMP_TEST (select * from QP_PREQ_RLTD_LINES_TMP);
1325: INSERT INTO QP_PREQ_LINE_ATTRS_TMP_TEST (select * from QP_PREQ_LINE_ATTRS_TMP);

Line 1326: INSERT INTO QP_PREQ_LINES_TMP_TEST (select * from QP_PREQ_LINES_TMP);

1322: DELETE FROM QP_PREQ_LDETS_TMP_TEST;
1323:
1324: INSERT INTO QP_PREQ_RLTD_LINES_TMP_TEST (select * from QP_PREQ_RLTD_LINES_TMP);
1325: INSERT INTO QP_PREQ_LINE_ATTRS_TMP_TEST (select * from QP_PREQ_LINE_ATTRS_TMP);
1326: INSERT INTO QP_PREQ_LINES_TMP_TEST (select * from QP_PREQ_LINES_TMP);
1327: INSERT INTO QP_PREQ_LDETS_TMP_TEST (select * from QP_PREQ_LDETS_TMP);
1328: END IF;
1329: */
1330: --

Line 1405: ,QP_PREQ_LINES_TMP QLUP

1401: CURSOR upd_line_det_cur IS
1402: SELECT ADJ.price_adjustment_id
1403: ,LDUP.line_detail_index
1404: FROM QP_LDETS_V LDUP
1405: ,QP_PREQ_LINES_TMP QLUP
1406: ,PO_PRICE_ADJUSTMENTS_DRAFT ADJ
1407: WHERE LDUP.process_code IN (QP_PREQ_GRP.G_STATUS_NEW, QP_PREQ_GRP.G_STATUS_UPDATED)
1408: AND LDUP.list_line_id = ADJ.list_line_id
1409: AND ADJ.po_line_id = QLUP.line_id

Line 1599: FROM QP_PREQ_LINES_TMP QLINE

1595: END IF;
1596: BEGIN
1597: SELECT QLINE.line_id, QLINE.price_flag, QLINE.line_index
1598: INTO l_line_id, l_price_flag, l_line_index
1599: FROM QP_PREQ_LINES_TMP QLINE
1600: WHERE QLINE.line_id = p_order_line_id_tbl(j)
1601: AND QLINE.line_type_code = 'LINE'
1602: AND QLINE.price_flag IN ('Y')
1603: AND QLINE.process_status <> 'NOT_VALID'

Line 2060: , QP_PREQ_LINES_TMP QLINE

2056: , LDETS.operand_value -- OPERAND_PER_PQTY
2057: , LDETS.adjustment_amount -- ADJUSTED_AMOUNT_PER_PQTY
2058: , 1 -- LOCK_CONTROL
2059: FROM QP_LDETS_v LDETS
2060: , QP_PREQ_LINES_TMP QLINE
2061: , QP_LIST_HEADERS_B QH
2062: WHERE LDETS.list_header_id = QH.list_header_id
2063: AND LDETS.process_code = QP_PREQ_GRP.G_STATUS_NEW
2064: AND QLINE.pricing_status_code IN (QP_PREQ_GRP.G_STATUS_NEW, QP_PREQ_GRP.G_STATUS_UPDATED)

Line 2086: , QP_PREQ_LINES_TMP QPL

2082: , RADJ.price_adjustment_id
2083: BULK COLLECT INTO l_price_adjustment_id_tbl
2084: ,l_rltd_price_adj_id_tbl
2085: FROM QP_PREQ_RLTD_LINES_TMP RLTD
2086: , QP_PREQ_LINES_TMP QPL
2087: , PO_PRICE_ADJUSTMENTS_DRAFT ADJ
2088: , PO_PRICE_ADJUSTMENTS_DRAFT RADJ
2089: WHERE QPL.LINE_INDEX = RLTD.LINE_INDEX
2090: AND QPL.LINE_ID = ADJ.PO_LINE_ID

Line 2130: FROM QP_PREQ_LINES_TMP QPL

2126: l_progress VARCHAR2(4):= '370';
2127:
2128: CURSOR refresh_attribs_cur IS
2129: SELECT ADJ.price_adjustment_id, ldets.line_detail_index
2130: FROM QP_PREQ_LINES_TMP QPL
2131: , PO_PRICE_ADJUSTMENTS_DRAFT ADJ
2132: , QP_LDETS_V LDETS
2133: WHERE LDETS.list_line_id = ADJ.list_line_id
2134: AND ADJ.draft_id = p_draft_id --For now draft_id in this place can never be null, but this condition needs to be changed or removed if null value is allowed in draft_id

Line 2311: , QP_PREQ_LINES_TMP QPLINE

2307: , 1
2308: FROM QP_PREQ_LINE_ATTRS_TMP QPLAT
2309: , QP_LDETS_v LDETS
2310: , PO_PRICE_ADJUSTMENTS_DRAFT ADJ
2311: , QP_PREQ_LINES_TMP QPLINE
2312: WHERE ADJ.po_header_id = p_order_header_id
2313: AND QPLAT.pricing_status_code = QP_PREQ_PUB.G_STATUS_NEW
2314: AND QPLAT.line_detail_index = LDETS.line_detail_index
2315: AND QPLAT.line_index = LDETS.line_index