APPS.CTO_AUTO_PROCURE_PK dependencies on MTL_RESERVATIONS

Line 957: from mtl_reservations

953: l_source_document_type_id := cto_utility_pk.get_source_document_id ( pLineId => so_line.line_id );
954:
955: select sum(nvl(reservation_quantity, 0))
956: into l_inv_quantity
957: from mtl_reservations
958: where demand_source_type_id = decode (l_source_document_type_id, 10, inv_reservation_global.g_source_type_internal_ord, inv_reservation_global.g_source_type_oe ) -- bugfix 1799874
959: and demand_source_line_id = so_line.line_id;
960:
961: -- if there is no reservation on the line that meens this line is

Line 1864: FROM mtl_reservations

1860:
1861: -- select the reservation quantities from the reservations tables.
1862: SELECT nvl(SUM(reservation_quantity), 0)
1863: INTO v_rsv_quantity
1864: FROM mtl_reservations
1865: WHERE demand_source_line_id = p_line_id;
1866:
1867: Return (v_rsv_quantity);
1868: EXCEPTION

Line 1925: FROM mtl_reservations

1921: AND process_flag is null;
1922:
1923: CURSOR c2(p_line_id NUMBER) IS
1924: SELECT nvl(SUM(reservation_quantity), 0) qty
1925: FROM mtl_reservations
1926: WHERE demand_source_line_id = p_interface_source_line_id;
1927:
1928: l_quantity_interface po_requisitions_interface_all.quantity%TYPE;
1929: l_open_flow_qty Number := 0;

Line 2013: from mtl_reservations

2009:
2010: l_inv_qty := 0;
2011: select nvl(sum(reservation_quantity), 0)
2012: into l_inv_qty
2013: from mtl_reservations
2014: where demand_source_type_id = decode (l_source_document_type_id, 10, inv_reservation_global.g_source_type_internal_ord,
2015: inv_reservation_global.g_source_type_oe )
2016: and demand_source_line_id = so_line.line_id
2017: and supply_source_type_id = inv_reservation_global.g_source_type_inv;

Line 2022: from mtl_reservations

2018:
2019: l_po_qty := 0;
2020: select nvl(sum(reservation_quantity), 0)
2021: into l_po_qty
2022: from mtl_reservations
2023: where demand_source_type_id = decode (l_source_document_type_id, 10, inv_reservation_global.g_source_type_internal_ord,
2024: inv_reservation_global.g_source_type_oe )
2025: and demand_source_line_id = so_line.line_id
2026: and supply_source_type_id = inv_reservation_global.g_source_type_po;

Line 2031: from mtl_reservations

2027:
2028: l_req_qty := 0;
2029: select nvl(sum(reservation_quantity), 0)
2030: into l_req_qty
2031: from mtl_reservations
2032: where demand_source_type_id = decode (l_source_document_type_id, 10, inv_reservation_global.g_source_type_internal_ord,
2033: inv_reservation_global.g_source_type_oe )
2034: and demand_source_line_id = so_line.line_id
2035: and supply_source_type_id = inv_reservation_global.g_source_type_req;