APPS.CTO_UTILITY_PK dependencies on MTL_RESERVATIONS

Line 3872: from mtl_reservations mr

3868: -- Removed the exception
3869:
3870: select nvl(sum(mr.primary_reservation_quantity),0)
3871: into l_reservation_qty
3872: from mtl_reservations mr
3873: where mr.demand_source_type_id = decode (l_source_document_type_id, 10,
3874: inv_reservation_global.g_source_type_internal_ord,
3875: inv_reservation_global.g_source_type_oe )
3876: and mr.primary_reservation_quantity > 0

Line 4539: from mtl_reservations mr,

4535:
4536:
4537: CURSOR c_rsv_details IS
4538: select reservation_id,reservation_quantity,supply_source_type_id
4539: from mtl_reservations mr,
4540: oe_order_lines_all oel,
4541: oe_order_headers_all oeh,
4542: oe_transaction_types_all ota,
4543: oe_transaction_types_tl otl,

Line 5638: l_reservation_id mtl_reservations.reservation_id%type;

5634: x_result out nocopy boolean,
5635: X_Msg_Count out nocopy number,
5636: X_Msg_Data out nocopy varchar2) as
5637:
5638: l_reservation_id mtl_reservations.reservation_id%type;
5639:
5640: BEGIN
5641:
5642: IF PG_DEBUG <> 0 THEN

Line 5659: mtl_reservations mr,

5655:
5656: SELECT reservation_id
5657: INTO l_reservation_id
5658: FROM
5659: mtl_reservations mr,
5660: oe_order_lines_all oel,
5661: oe_order_headers_all oeh,
5662: oe_transaction_types_all ota,
5663: oe_transaction_types_tl otl,

Line 7196: from mtl_reservations

7192: CURSOR c_resv IS
7193: select sum(nvl(primary_reservation_quantity,0)) primary_reservation_quantity,--bugfix2466429
7194: sum(nvl(reservation_quantity,0)) secondary_reservation_quantity, --OPM
7195: supply_source_type_id
7196: from mtl_reservations
7197: where demand_source_type_id = decode (l_source_document_type_id, 10,
7198: inv_reservation_global.g_source_type_internal_ord,
7199: inv_reservation_global.g_source_type_oe ) -- bugfix 1799874
7200: and demand_source_line_id = p_order_line_id