APPS.CTO_AUTO_PROCURE_PK dependencies on MTL_RESERVATIONS

Line 649: from mtl_reservations

645: reservation_quantity,
646: primary_reservation_quantity,
647: supply_source_type_id,
648: supply_source_header_id
649: from mtl_reservations
650: where demand_source_line_id = p_cursor_line_id;
651:
652: CURSOR debug_shipping_info(p_cursor_line_id number) is
653: SELECT released_status,

Line 1118: from mtl_reservations

1114: l_source_document_type_id := cto_utility_pk.get_source_document_id ( pLineId => so_line.line_id );
1115:
1116: select sum(nvl(reservation_quantity, 0))
1117: into l_inv_quantity
1118: from mtl_reservations
1119: 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
1120: and demand_source_line_id = so_line.line_id;
1121:
1122: -- if there is no reservation on the line that meens this line is

Line 2188: FROM mtl_reservations

2184:
2185: -- select the reservation quantities from the reservations tables.
2186: SELECT nvl(SUM(reservation_quantity), 0)
2187: INTO v_rsv_quantity
2188: FROM mtl_reservations
2189: WHERE demand_source_line_id = p_line_id;
2190:
2191: Return (v_rsv_quantity);
2192: EXCEPTION

Line 2252: FROM mtl_reservations

2248: AND process_flag is null;
2249:
2250: CURSOR c2(p_line_id NUMBER) IS
2251: SELECT nvl(SUM(reservation_quantity), 0) qty
2252: FROM mtl_reservations
2253: WHERE demand_source_line_id = p_interface_source_line_id;
2254:
2255: l_quantity_interface po_requisitions_interface_all.quantity%TYPE;
2256: l_open_flow_qty Number := 0;

Line 2398: from mtl_reservations

2394:
2395: l_inv_qty := 0;
2396: select nvl(sum(reservation_quantity), 0)
2397: into l_inv_qty
2398: from mtl_reservations
2399: where demand_source_type_id = decode (l_source_document_type_id, 10, inv_reservation_global.g_source_type_internal_ord,
2400: inv_reservation_global.g_source_type_oe )
2401: and demand_source_line_id = so_line.line_id
2402: and supply_source_type_id = inv_reservation_global.g_source_type_inv;

Line 2407: from mtl_reservations

2403:
2404: l_po_qty := 0;
2405: select nvl(sum(reservation_quantity), 0)
2406: into l_po_qty
2407: from mtl_reservations
2408: where demand_source_type_id = decode (l_source_document_type_id, 10, inv_reservation_global.g_source_type_internal_ord,
2409: inv_reservation_global.g_source_type_oe )
2410: and demand_source_line_id = so_line.line_id
2411: and supply_source_type_id = inv_reservation_global.g_source_type_po;

Line 2416: from mtl_reservations

2412:
2413: l_req_qty := 0;
2414: select nvl(sum(reservation_quantity), 0)
2415: into l_req_qty
2416: from mtl_reservations
2417: where demand_source_type_id = decode (l_source_document_type_id, 10, inv_reservation_global.g_source_type_internal_ord,
2418: inv_reservation_global.g_source_type_oe )
2419: and demand_source_line_id = so_line.line_id
2420: and supply_source_type_id = inv_reservation_global.g_source_type_req;