[Home] [Help]
100: --| promised_date from PO_LINE_LOCATIONS_ALL |
101: --| if need_by_date is NULL. |
102: --| 08/24/2006 vchu Fixed bug 5485115: Remove the dependency on |
103: --| OE_PRICE_LIST_LINES in by querying the base |
104: --| table QP_LIST_LINES to get the unit_code |
105: --| and list_price for the specific |
106: --| subcontracting component. |
107: --| 11/08/2006 vchu Fixed bug 5649321: Added an additional |
108: --| where clause condition in the query to get |
1046: -- synonym on QP_PRICE_LIST_LINES_V that has a where clause condition that
1047: -- calls QP_UTIL.Get_Item_Validation_Org, which returns the value of
1048: -- the QP: Item Validation Organization profile option.
1049: -- The following query was rewritten to select from the based table
1050: -- QP_LIST_LINES, instead of the OE_PRICE_LIST_LINES view.
1051:
1052: /* Commenting as part of bugfix 9315131. Rewriting this sql.
1053: SELECT qp_price_list_pvt.get_product_uom_code(list_line_id),
1054: operand
1053: SELECT qp_price_list_pvt.get_product_uom_code(list_line_id),
1054: operand
1055: INTO l_price_list_uom,
1056: l_component_price
1057: FROM qp_list_lines
1058: WHERE list_header_id = l_price_list_id
1059: AND qp_price_list_pvt.get_inventory_item_id(list_line_id) = p_item_id
1060: AND l_ship_date BETWEEN
1061: NVL(start_date_active, l_ship_date - 1)
1068: SELECT qp_price_list_pvt.get_product_uom_code(qp.list_line_id),
1069: qp.operand
1070: INTO l_price_list_uom,
1071: l_component_price
1072: FROM qp_list_lines qp
1073: WHERE qp.list_header_id = l_price_list_id
1074: AND EXISTS (SELECT 1
1075: FROM qp_pricing_attributes qpa
1076: WHERE qpa.list_line_id = qp.list_line_id