APPS.INV_RSV_SYNCH dependencies on MTL_RESERVATIONS

Line 41: from mtl_reservations

37: from dual;
38:
39: select demand_source_type_id
40: into l_demand_source_type_id
41: from mtl_reservations
42: where reservation_id = p_reservation_id;
43:
44: /* Insert demand into MTL_DEMAND for Non-Orders */
45:

Line 223: from mtl_reservations a

219: ,NULL /* ORDERED_ITEM_ID */
220: ,NULL /* CONFIG_GROUP_ID */
221: ,NULL /* OPERATION_SEQ_NUM */
222: ,p_reservation_id
223: from mtl_reservations a
224: where a.reservation_id = p_reservation_id;
225: end if;
226:
227: /* Insert reservation into MTL_DEMAND */

Line 404: from mtl_reservations a

400: ,NULL /* ORDERED_ITEM_ID */
401: ,NULL /* CONFIG_GROUP_ID */
402: ,NULL /* OPERATION_SEQ_NUM */
403: ,p_reservation_id
404: from mtl_reservations a
405: where a.reservation_id = p_reservation_id;
406:
407: update mtl_reservations
408: set n_column1 = l_demand_id_rsv

Line 407: update mtl_reservations

403: ,p_reservation_id
404: from mtl_reservations a
405: where a.reservation_id = p_reservation_id;
406:
407: update mtl_reservations
408: set n_column1 = l_demand_id_rsv
409: where reservation_id = p_reservation_id;
410:
411: inv_rsv_trigger_global.g_from_trigger := FALSE;

Line 455: from mtl_reservations

451: inv_rsv_trigger_global.g_from_trigger := TRUE;
452:
453: select demand_source_type_id
454: into l_demand_source_type_id
455: from mtl_reservations
456: where reservation_id = p_reservation_id;
457:
458: /* Update demand in MTL_DEMAND for Non-Orders */
459: if (l_demand_source_type_id not in (2,8,12)) then

Line 629: from mtl_reservations b

625: ,NULL /* EXPLOSION_GROUP_ID */
626: ,NULL /* ORDERED_ITEM_ID */
627: ,NULL /* CONFIG_GROUP_ID */
628: ,NULL /* OPERATION_SEQ_NUM */
629: from mtl_reservations b
630: where b.reservation_id = p_reservation_id)
631: where a.n_column1 = p_reservation_id
632: and a.reservation_type = 1
633: and a.parent_demand_id is null;

Line 808: from mtl_reservations b

804: ,NULL /* ORDERED_ITEM_ID */
805: ,NULL /* CONFIG_GROUP_ID */
806: ,NULL /* OPERATION_SEQ_NUM */
807: ,decode(b.SUPPLY_SOURCE_TYPE_ID,13,2,3) /* RESERVATION_TYPE */
808: from mtl_reservations b
809: where b.reservation_id = p_reservation_id)
810: where a.n_column1 = p_reservation_id
811: and a.reservation_type in (2,3)
812: and a.parent_demand_id is not null;

Line 858: from mtl_reservations

854: inv_rsv_trigger_global.g_from_trigger := TRUE;
855:
856: select demand_source_type_id
857: into l_demand_source_type_id
858: from mtl_reservations
859: where reservation_id = p_reservation_id;
860:
861: /* Delete demand in MTL_DEMAND for Non-Orders */
862: if (l_demand_source_type_id not in (2,8,12)) then

Line 923: from mtl_reservations

919: inv_rsv_trigger_global.g_from_trigger := TRUE;
920:
921: select demand_source_type_id
922: into l_demand_source_type_id
923: from mtl_reservations
924: where reservation_id = p_reservation_id;
925:
926: --inv_debug.message('tst115', 'l_demand_source_type_id is ' || l_demand_source_type_id);
927: