APPS.WIP_ATO_UTILS dependencies on MTL_DEMAND

Line 50: /* Check to see if there is a record in mtl_demand corresponding to this

46: BEGIN
47: x_wip_entity_id := 0;
48: x_wip_entity_type := 0;
49:
50: /* Check to see if there is a record in mtl_demand corresponding to this
51: * sales order Optionally the supply source id can be provided so that
52: * we don't have to select from MTL_DEMAND.
53: */
54:

Line 52: * we don't have to select from MTL_DEMAND.

48: x_wip_entity_type := 0;
49:
50: /* Check to see if there is a record in mtl_demand corresponding to this
51: * sales order Optionally the supply source id can be provided so that
52: * we don't have to select from MTL_DEMAND.
53: */
54:
55: IF p_supply_source_id = -1 THEN
56: DECLARE

Line 59: FROM mtl_demand

55: IF p_supply_source_id = -1 THEN
56: DECLARE
57: BEGIN
58: SELECT supply_source_header_id INTO x_wip_entity_id
59: FROM mtl_demand
60: WHERE organization_id = p_org_id
61: AND supply_source_type = 5
62: AND demand_source_header_id = p_so_header_id
63: AND demand_source_line = p_so_line

Line 78: /* If a row is found in mtl_demand then get its wip entity type. */

74: x_wip_entity_id := Nvl(p_supply_source_id,0);
75: END IF;
76:
77: IF(x_wip_entity_id > 0) THEN
78: /* If a row is found in mtl_demand then get its wip entity type. */
79:
80: SELECT entity_type INTO x_wip_entity_type
81: FROM wip_entities
82: WHERE wip_entity_id = x_wip_entity_id;

Line 85: /* If no row was found in mtl_demand check interface table for

81: FROM wip_entities
82: WHERE wip_entity_id = x_wip_entity_id;
83:
84: ELSE
85: /* If no row was found in mtl_demand check interface table for
86: * any flow schedules that haven't been picked up yet
87: */
88:
89: DECLARE

Line 129: * Output : The output of this function is the quantity open in mtl_demand

125: * get_so_open_qty :
126: * Description: This procedure is used to return the quantity in a given
127: * sales order that is open for reservation.
128: * Input : Sales order header, line and delivery id.
129: * Output : The output of this function is the quantity open in mtl_demand
130: *
131: ***************************************************************************/
132:
133:

Line 144: /* get the open quantity from mtl_demand */

140: p_err_msg IN OUT NOCOPY VARCHAR2) IS
141: x_qty NUMBER;
142: BEGIN
143:
144: /* get the open quantity from mtl_demand */
145:
146: DECLARE
147: BEGIN
148: SELECT Nvl(primary_uom_quantity,0) INTO x_qty

Line 149: FROM mtl_demand

145:
146: DECLARE
147: BEGIN
148: SELECT Nvl(primary_uom_quantity,0) INTO x_qty
149: FROM mtl_demand
150: WHERE organization_id = p_org_id
151: AND demand_source_header_id = p_so_header_id
152: AND demand_source_line = p_so_line
153: AND demand_source_delivery = p_so_delivery