DBA Data[Home] [Help]

APPS.OE_ADV_PRICE_PVT dependencies on QP_PREQ_LINE_ATTRS_TMP

Line 1409: FROM qp_preq_line_attrs_tmp attr

1405: G_STMT_NO := 'Process_Other_Item_Line#140';
1406: Begin
1407: SELECT attr.value_from
1408: INTO l_line_rec.inventory_item_id
1409: FROM qp_preq_line_attrs_tmp attr
1410: WHERE attr.context = 'ITEM'
1411: AND attr.attribute =
1412: 'PRICING_ATTRIBUTE1'
1413: AND attr.line_index = p_line_index;

Line 1840: FROM qp_preq_line_attrs_tmp attr

1836: -- getting the free good item id
1837:
1838: SELECT attr.value_from
1839: INTO l_inventory_item_id
1840: FROM qp_preq_line_attrs_tmp attr
1841: WHERE attr.context = 'ITEM'
1842: AND attr.attribute = 'PRICING_ATTRIBUTE1'
1843: AND attr.line_index = i.line_index;
1844: