[Home] [Help]
557: /*B4905079 - Changed the cursor to improve the performance*/
558: CURSOR Cur_omso_doc_no IS
559: SELECT DISTINCT oh.order_number
560: FROM oe_order_headers_all oh,
561: oe_order_lines_all ol
562: WHERE oh.header_id = ol.header_id
563: AND inv_salesorder.get_salesorder_for_oeheader(ol.header_id) = G_doc_id
564: AND ol.open_flag = 'Y'
565: AND ol.visible_demand_flag = 'Y' /*B4905079 - Flag to ensure that available_to_mrp = 1 */
570: /*B4905079 - Changed the cursor to improve the performance*/
571: CURSOR Cur_excl_internal_omso_doc_no IS
572: SELECT DISTINCT oh.order_number
573: FROM oe_order_headers_all oh,
574: oe_order_lines_all ol
575: WHERE oh.header_id = ol.header_id
576: AND inv_salesorder.get_salesorder_for_oeheader(ol.header_id) = G_doc_id
577: AND ol.open_flag = 'Y'
578: AND ol.visible_demand_flag = 'Y' /*B4905079 - Flag to ensure that available_to_mrp = 1 */
827: 'FROM '||
828: ' mtl_demand_omoe mtl, '||
829: ' mtl_system_items items, '||
830: ' oe_order_headers_all hdr, '||
831: ' oe_order_lines_all dtl, '||
832: ' hr_organization_units hou, '||
833: ' mtl_parameters org '||
834: ' WHERE '||
835: ' mtl.inventory_item_id = TO_CHAR(:item_id) '||
1653: --Modified to name from customer_number as per bug # 11068148
1654: SELECT DISTINCT substr(sold_to_org.name,1,40)
1655: --DISTINCT sold_to_org.customer_number
1656: FROM oe_order_headers_all oh,
1657: oe_order_lines_all ol,
1658: oe_sold_to_orgs_v sold_to_org,
1659: mtl_demand_omoe mtl
1660: WHERE oh.header_id = ol.header_id
1661: AND ol.line_id = mtl.demand_id
1672: --Modified to name from customer_number as per bug # 11068148
1673: SELECT DISTINCT substr(sold_to_org.name,1,40)
1674: -- DISTINCT sold_to_org.customer_number
1675: FROM oe_order_headers_all oh,
1676: oe_order_lines_all ol,
1677: oe_sold_to_orgs_v sold_to_org,
1678: mtl_demand_omoe mtl
1679: WHERE oh.header_id = ol.header_id
1680: AND ol.line_id = mtl.demand_id