eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.INV_RSV_SYNCH dependencies on MTL_DEMAND

Line 31: select mtl_demand_s.nextval

27:
28: /*
29: ** Get sequence value for demand_id and parent_demand_id
30: */
31: select mtl_demand_s.nextval
32: into l_demand_id_dmd
33: from dual;
34:
35: select mtl_demand_s.nextval

Line 35: select mtl_demand_s.nextval

31: select mtl_demand_s.nextval
32: into l_demand_id_dmd
33: from dual;
34:
35: select mtl_demand_s.nextval
36: into l_demand_id_rsv
37: from dual;
38:
39: select demand_source_type_id

Line 44: /* Insert demand into MTL_DEMAND for Non-Orders */

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:
46: if (l_demand_source_type_id not in (2,8,12)) then
47: insert into mtl_demand(
48: DEMAND_ID

Line 47: insert into mtl_demand(

43:
44: /* Insert demand into MTL_DEMAND for Non-Orders */
45:
46: if (l_demand_source_type_id not in (2,8,12)) then
47: insert into mtl_demand(
48: DEMAND_ID
49: ,ORGANIZATION_ID
50: ,INVENTORY_ITEM_ID
51: ,DEMAND_SOURCE_TYPE

Line 227: /* Insert reservation into MTL_DEMAND */

223: from mtl_reservations a
224: where a.reservation_id = p_reservation_id;
225: end if;
226:
227: /* Insert reservation into MTL_DEMAND */
228: insert into mtl_demand(
229: DEMAND_ID
230: ,ORGANIZATION_ID
231: ,INVENTORY_ITEM_ID

Line 228: insert into mtl_demand(

224: where a.reservation_id = p_reservation_id;
225: end if;
226:
227: /* Insert reservation into MTL_DEMAND */
228: insert into mtl_demand(
229: DEMAND_ID
230: ,ORGANIZATION_ID
231: ,INVENTORY_ITEM_ID
232: ,DEMAND_SOURCE_TYPE

Line 458: /* Update demand in MTL_DEMAND for Non-Orders */

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
460: update mtl_demand a
461: set (
462: a.ORGANIZATION_ID

Line 460: update mtl_demand a

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
460: update mtl_demand a
461: set (
462: a.ORGANIZATION_ID
463: ,a.INVENTORY_ITEM_ID
464: ,a.DEMAND_SOURCE_TYPE

Line 636: /* Update reservation in MTL_DEMAND */

632: and a.reservation_type = 1
633: and a.parent_demand_id is null;
634: end if;
635:
636: /* Update reservation in MTL_DEMAND */
637: update mtl_demand a
638: set (
639: a.ORGANIZATION_ID
640: ,a.INVENTORY_ITEM_ID

Line 637: update mtl_demand a

633: and a.parent_demand_id is null;
634: end if;
635:
636: /* Update reservation in MTL_DEMAND */
637: update mtl_demand a
638: set (
639: a.ORGANIZATION_ID
640: ,a.INVENTORY_ITEM_ID
641: ,a.DEMAND_SOURCE_TYPE

Line 861: /* Delete demand in MTL_DEMAND for Non-Orders */

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
863: delete mtl_demand
864: where n_column1 = p_reservation_id
865: and reservation_type = 1

Line 863: delete mtl_demand

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
863: delete mtl_demand
864: where n_column1 = p_reservation_id
865: and reservation_type = 1
866: and parent_demand_id is null;
867: end if;

Line 869: /* Delete reservation in MTL_DEMAND */

865: and reservation_type = 1
866: and parent_demand_id is null;
867: end if;
868:
869: /* Delete reservation in MTL_DEMAND */
870: delete mtl_demand
871: where n_column1 = p_reservation_id
872: and reservation_type in (2,3)
873: and parent_demand_id is not null;

Line 870: delete mtl_demand

866: and parent_demand_id is null;
867: end if;
868:
869: /* Delete reservation in MTL_DEMAND */
870: delete mtl_demand
871: where n_column1 = p_reservation_id
872: and reservation_type in (2,3)
873: and parent_demand_id is not null;
874:

Line 928: /* Update completed_quantity for demand in MTL_DEMAND for Non-Orders */

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:
928: /* Update completed_quantity for demand in MTL_DEMAND for Non-Orders */
929: if (l_demand_source_type_id not in (2,8,12)) then
930: begin
931: --inv_debug.message('tst115', 'update mtl_demand for non-orders');
932: update mtl_demand

Line 931: --inv_debug.message('tst115', 'update mtl_demand for non-orders');

927:
928: /* Update completed_quantity for demand in MTL_DEMAND for Non-Orders */
929: if (l_demand_source_type_id not in (2,8,12)) then
930: begin
931: --inv_debug.message('tst115', 'update mtl_demand for non-orders');
932: update mtl_demand
933: set completed_quantity = completed_quantity + p_primary_relieved_quantity
934: where n_column1 = p_reservation_id
935: and reservation_type = 1

Line 932: update mtl_demand

928: /* Update completed_quantity for demand in MTL_DEMAND for Non-Orders */
929: if (l_demand_source_type_id not in (2,8,12)) then
930: begin
931: --inv_debug.message('tst115', 'update mtl_demand for non-orders');
932: update mtl_demand
933: set completed_quantity = completed_quantity + p_primary_relieved_quantity
934: where n_column1 = p_reservation_id
935: and reservation_type = 1
936: and parent_demand_id is null;

Line 943: /* Update completed_quantity for reservation in MTL_DEMAND */

939: null;
940: end;
941: end if;
942:
943: /* Update completed_quantity for reservation in MTL_DEMAND */
944: begin
945: --inv_debug.message('tst115', 'update mtl_demand for orders');
946: update mtl_demand
947: set completed_quantity = completed_quantity + p_primary_relieved_quantity

Line 945: --inv_debug.message('tst115', 'update mtl_demand for orders');

941: end if;
942:
943: /* Update completed_quantity for reservation in MTL_DEMAND */
944: begin
945: --inv_debug.message('tst115', 'update mtl_demand for orders');
946: update mtl_demand
947: set completed_quantity = completed_quantity + p_primary_relieved_quantity
948: where n_column1 = p_reservation_id
949: and reservation_type in (2,3)

Line 946: update mtl_demand

942:
943: /* Update completed_quantity for reservation in MTL_DEMAND */
944: begin
945: --inv_debug.message('tst115', 'update mtl_demand for orders');
946: update mtl_demand
947: set completed_quantity = completed_quantity + p_primary_relieved_quantity
948: where n_column1 = p_reservation_id
949: and reservation_type in (2,3)
950: and parent_demand_id is not null;