[Home] [Help]
555: /*B4905079 - Changed the cursor to improve the performance*/
556: CURSOR Cur_omso_doc_no IS
557: SELECT DISTINCT oh.order_number
558: FROM oe_order_headers_all oh,
559: oe_order_lines_all ol
560: WHERE oh.header_id = ol.header_id
561: AND inv_salesorder.get_salesorder_for_oeheader(ol.header_id) = G_doc_id
562: AND ol.open_flag = 'Y'
563: AND ol.visible_demand_flag = 'Y' /*B4905079 - Flag to ensure that available_to_mrp = 1 */
568: /*B4905079 - Changed the cursor to improve the performance*/
569: CURSOR Cur_excl_internal_omso_doc_no IS
570: SELECT DISTINCT oh.order_number
571: FROM oe_order_headers_all oh,
572: oe_order_lines_all ol
573: WHERE oh.header_id = ol.header_id
574: AND inv_salesorder.get_salesorder_for_oeheader(ol.header_id) = G_doc_id
575: AND ol.open_flag = 'Y'
576: AND ol.visible_demand_flag = 'Y' /*B4905079 - Flag to ensure that available_to_mrp = 1 */
825: 'FROM '||
826: ' mtl_demand_omoe mtl, '||
827: ' mtl_system_items items, '||
828: ' oe_order_headers_all hdr, '||
829: ' oe_order_lines_all dtl, '||
830: ' hr_organization_units hou, '||
831: ' mtl_parameters org '||
832: ' WHERE '||
833: ' mtl.inventory_item_id = TO_CHAR(:item_id) '||
1637:
1638: CURSOR Cur_om_order_details IS
1639: SELECT DISTINCT sold_to_org.customer_number
1640: FROM oe_order_headers_all oh,
1641: oe_order_lines_all ol,
1642: oe_sold_to_orgs_v sold_to_org,
1643: mtl_demand_omoe mtl
1644: WHERE oh.header_id = ol.header_id
1645: AND ol.line_id = mtl.demand_id
1654: -- Internal Sales Orders profile was set to Y.
1655: CURSOR Cur_excl_internal_omso_dtl IS
1656: SELECT DISTINCT sold_to_org.customer_number
1657: FROM oe_order_headers_all oh,
1658: oe_order_lines_all ol,
1659: oe_sold_to_orgs_v sold_to_org,
1660: mtl_demand_omoe mtl
1661: WHERE oh.header_id = ol.header_id
1662: AND ol.line_id = mtl.demand_id