APPS.CTO_UTILITY_PK dependencies on MTL_RESERVATIONS

Line 3894: from mtl_reservations mr

3890: -- Removed the exception
3891:
3892: select nvl(sum(mr.primary_reservation_quantity),0)
3893: into l_reservation_qty
3894: from mtl_reservations mr
3895: where mr.demand_source_type_id = decode (l_source_document_type_id, 10,
3896: inv_reservation_global.g_source_type_internal_ord,
3897: inv_reservation_global.g_source_type_oe )
3898: and mr.primary_reservation_quantity > 0

Line 4563: from mtl_reservations mr,

4559:
4560:
4561: CURSOR c_rsv_details IS
4562: select reservation_id,reservation_quantity,supply_source_type_id
4563: from mtl_reservations mr,
4564: oe_order_lines_all oel,
4565: oe_order_headers_all oeh,
4566: oe_transaction_types_all ota,
4567: oe_transaction_types_tl otl,

Line 5662: l_reservation_id mtl_reservations.reservation_id%type;

5658: x_result out nocopy boolean,
5659: X_Msg_Count out nocopy number,
5660: X_Msg_Data out nocopy varchar2) as
5661:
5662: l_reservation_id mtl_reservations.reservation_id%type;
5663:
5664: BEGIN
5665:
5666: IF PG_DEBUG <> 0 THEN

Line 5683: mtl_reservations mr,

5679:
5680: SELECT reservation_id
5681: INTO l_reservation_id
5682: FROM
5683: mtl_reservations mr,
5684: oe_order_lines_all oel,
5685: oe_order_headers_all oeh,
5686: oe_transaction_types_all ota,
5687: oe_transaction_types_tl otl,

Line 7222: from mtl_reservations

7218: supply_source_type_id,
7219: --Bugfix 13554996
7220: lot_number,
7221: max(organization_id) organization_id
7222: from mtl_reservations
7223: where demand_source_type_id = decode (l_source_document_type_id, 10,
7224: inv_reservation_global.g_source_type_internal_ord,
7225: inv_reservation_global.g_source_type_oe ) -- bugfix 1799874
7226: and demand_source_line_id = p_order_line_id