DBA Data[Home] [Help]

APPS.PO_PRICE_ADJUSTMENTS_PKG dependencies on QP_PREQ_LINE_ATTRS_TMP

Line 1320: DELETE FROM QP_PREQ_LINE_ATTRS_TMP_TEST;

1316: END LOOP;
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);

Line 1325: INSERT INTO QP_PREQ_LINE_ATTRS_TMP_TEST (select * from QP_PREQ_LINE_ATTRS_TMP);

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);
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: */

Line 2172: FROM QP_PREQ_LINE_ATTRS_TMP QPLAT

2168: (SELECT QPLAT.context
2169: , QPLAT.attribute
2170: , QPLAT.setup_value_from
2171: , QPLAT.setup_value_to
2172: FROM QP_PREQ_LINE_ATTRS_TMP QPLAT
2173: WHERE QPLAT.pricing_status_code = QP_PREQ_PUB.G_STATUS_NEW
2174: AND QPLAT.line_detail_index = l_line_detail_index_tbl(i)
2175: );
2176:

Line 2226: FROM QP_PREQ_LINE_ATTRS_TMP QPLAT

2222: 'QUALIFIER', 'QP_ATTR_DEFNS_QUALIFIER',
2223: 'QP_ATTR_DEFNS_PRICING')
2224: , PO_PRICE_ADJ_ATTRIBS_S.nextval
2225: , 1
2226: FROM QP_PREQ_LINE_ATTRS_TMP QPLAT
2227: WHERE QPLAT.pricing_status_code = QP_PREQ_PUB.G_STATUS_NEW
2228: AND QPLAT.LINE_DETAIL_INDEX = l_line_detail_index_tbl(i)
2229: AND ( QPLAT.context
2230: , QPLAT.attribute

Line 2308: FROM QP_PREQ_LINE_ATTRS_TMP QPLAT

2304: 'QUALIFIER', 'QP_ATTR_DEFNS_QUALIFIER',
2305: 'QP_ATTR_DEFNS_PRICING')
2306: , PO_PRICE_ADJ_ATTRIBS_S.nextval
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