APPS.CTO_WORKBENCH_UTIL_PK dependencies on MTL_RESERVATIONS

Line 223: from mtl_reservations

219:
220:
221: select nvl(sum(reservation_quantity),0)
222: into v_wip_quantity
223: from mtl_reservations
224: where demand_source_type_id = decode (l_source_document_type_id, 10,
225: inv_reservation_global.g_source_type_internal_ord,
226: inv_reservation_global.g_source_type_oe )
227: and demand_source_line_id = l_demand_line_id

Line 258: from mtl_reservations

254: END IF;
255:
256: select nvl(sum(reservation_quantity),0)
257: into v_po_quantity
258: from mtl_reservations
259: where demand_source_type_id = decode (l_source_document_type_id,
260: 10, inv_reservation_global.g_source_type_internal_ord,
261: inv_reservation_global.g_source_type_oe )
262: and demand_source_line_id = l_demand_line_id

Line 282: from mtl_reservations

278: END IF;
279:
280: select nvl(sum(reservation_quantity), 0)
281: into v_req_quantity
282: from mtl_reservations
283: where demand_source_type_id = decode (l_source_document_type_id,
284: 10, inv_reservation_global.g_source_type_internal_ord,
285: inv_reservation_global.g_source_type_oe )
286: and demand_source_line_id = l_demand_line_id

Line 307: from mtl_reservations

303:
304: -- rkaza. 05/19/2005. ireq project.
305: select nvl(sum(reservation_quantity), 0)
306: into v_ireq_quantity
307: from mtl_reservations
308: where demand_source_type_id = decode (l_source_document_type_id,
309: 10, inv_reservation_global.g_source_type_internal_ord,
310: inv_reservation_global.g_source_type_oe )
311: and demand_source_line_id = l_demand_line_id

Line 332: from mtl_reservations

328: -- Added by Renga Kannan on 30-Jun-2005 for Cross docking project
329:
330: select nvl(sum(reservation_quantity), 0)
331: into v_asn_quantity
332: from mtl_reservations
333: where demand_source_type_id = decode (l_source_document_type_id,
334: 10, inv_reservation_global.g_source_type_internal_ord,
335: inv_reservation_global.g_source_type_oe )
336: and demand_source_line_id = l_demand_line_id

Line 610: l_prim_uom_code mtl_reservations.primary_uom_code%type;

606: p_ato_line_id IN Number,
607: p_item_type_code IN varchar2) RETURN Number is
608: l_prim_rsv_qty Number;
609: l_rsv_qty Number;
610: l_prim_uom_code mtl_reservations.primary_uom_code%type;
611: l_line_id Number;
612:
613: Begin
614: -- -- Fixed bug 5199341

Line 631: from mtl_reservations

627: End if;
628:
629: select sum(primary_reservation_quantity),primary_uom_code
630: into l_prim_rsv_qty, l_prim_uom_code
631: from mtl_reservations
632: where demand_source_line_id = l_line_id
633: and supply_source_TYpe_id = 13
634: group by primary_uom_code;
635:

Line 694: FROM mtl_reservations mr, wip_discrete_jobs wdj

690: --
691: Select max(exp_comp_date) into l_date
692: from
693: (SELECT wdj.scheduled_completion_date exp_comp_date
694: FROM mtl_reservations mr, wip_discrete_jobs wdj
695: WHERE mr.demand_source_type_id = decode(CTO_WORKBENCH_UTIL_PK.get_source_document_id(l_config_line_id), 10,8,2)
696: AND mr.demand_source_line_id = l_config_line_id
697: AND mr.supply_source_type_id = 5
698: AND wdj.wip_entity_id = mr.supply_source_header_id

Line 711: from mtl_reservations mr, po_line_locations_all poll

707:
708: UNION
709:
710: select nvl(poll.promised_date,poll.need_by_date) exp_comp_date
711: from mtl_reservations mr, po_line_locations_all poll
712: where mr.demand_source_type_id = 2
713: and mr.demand_source_line_id = l_config_line_id
714: and mr.supply_source_type_id = 1
715: and mr.supply_source_header_id = poll.po_header_id

Line 721: from mtl_reservations mr, po_requisition_lines_all porl

717:
718: UNION
719:
720: select porl.need_by_date exp_comp_date
721: from mtl_reservations mr, po_requisition_lines_all porl
722: where mr.demand_source_type_id = 2
723: and mr.demand_source_line_id = l_config_line_id
724: and mr.supply_source_type_id in (7, 17)
725: and mr.supply_source_header_id = porl.requisition_header_id

Line 748: from mtl_reservations mr,

744:
745: UNION
746:
747: select asn_headers.expected_receipt_date exp_comp_date
748: from mtl_reservations mr,
749: rcv_shipment_lines ASN_LINES,
750: rcv_shipment_headers asn_headers
751: where mr.demand_source_type_id = 2
752: and mr.demand_source_line_id = l_config_line_id

Line 789: l_prim_uom_code mtl_reservations.primary_uom_code%type;

785: p_ato_line_id IN Number,
786: p_item_type_code IN varchar2) RETURN Number is
787: l_prim_rsv_qty Number;
788: l_rsv_qty Number;
789: l_prim_uom_code mtl_reservations.primary_uom_code%type;
790: l_line_id Number;
791:
792: Begin
793:

Line 812: from mtl_reservations

808: End if;
809:
810: select sum(primary_reservation_quantity),primary_uom_code
811: into l_prim_rsv_qty, l_prim_uom_code
812: from mtl_reservations
813: where demand_source_line_id = l_line_id
814: and supply_source_TYpe_id = 27
815: group by primary_uom_code;
816: