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.CTO_WORKBENCH_UTIL_PK dependencies on MTL_RESERVATIONS

Line 226: from mtl_reservations

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

Line 261: from mtl_reservations

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

Line 285: from mtl_reservations

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

Line 310: from mtl_reservations

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

Line 335: from mtl_reservations

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

Line 660: --l_prim_uom_code mtl_reservations.primary_uom_code%type;

656: p_ato_line_id IN Number,
657: p_item_type_code IN varchar2) RETURN Number is
658: --l_prim_rsv_qty Number;
659: l_rsv_qty Number;
660: --l_prim_uom_code mtl_reservations.primary_uom_code%type;
661: l_line_id Number;
662:
663: --Bugfix 13554996: New variable and cursor.
664: l_order_uom oe_order_lines_all.order_quantity_uom%type;

Line 675: from mtl_reservations

671: nvl(sum(primary_reservation_quantity), 0),
672: x_item_id,
673: lot_number,
674: max(organization_id)) primary_reservation_quantity
675: from mtl_reservations
676: where demand_source_line_id = x_line_id
677: and supply_source_TYpe_id = 13
678: group by primary_uom_code, lot_number;
679:

Line 700: from mtl_reservations

696:
697: /*Begin Bugfix 13554996: Converted this sql to a cursor
698: select sum(primary_reservation_quantity),primary_uom_code
699: into l_prim_rsv_qty, l_prim_uom_code
700: from mtl_reservations
701: where demand_source_line_id = l_line_id
702: and supply_source_TYpe_id = 13
703: group by primary_uom_code;
704:

Line 784: FROM mtl_reservations mr, wip_discrete_jobs wdj

780: --
781: Select max(exp_comp_date) into l_date
782: from
783: (SELECT wdj.scheduled_completion_date exp_comp_date
784: FROM mtl_reservations mr, wip_discrete_jobs wdj
785: WHERE mr.demand_source_type_id = decode(CTO_WORKBENCH_UTIL_PK.get_source_document_id(l_config_line_id), 10,8,2)
786: AND mr.demand_source_line_id = l_config_line_id
787: AND mr.supply_source_type_id = 5
788: AND wdj.wip_entity_id = mr.supply_source_header_id

Line 801: from mtl_reservations mr, po_line_locations_all poll

797:
798: UNION
799:
800: select nvl(poll.promised_date,poll.need_by_date) exp_comp_date
801: from mtl_reservations mr, po_line_locations_all poll
802: where mr.demand_source_type_id = 2
803: and mr.demand_source_line_id = l_config_line_id
804: and mr.supply_source_type_id = 1
805: and mr.supply_source_header_id = poll.po_header_id

Line 811: from mtl_reservations mr, po_requisition_lines_all porl

807:
808: UNION
809:
810: select porl.need_by_date exp_comp_date
811: from mtl_reservations mr, po_requisition_lines_all porl
812: where mr.demand_source_type_id = 2
813: and mr.demand_source_line_id = l_config_line_id
814: and mr.supply_source_type_id in (7, 17)
815: and mr.supply_source_header_id = porl.requisition_header_id

Line 838: from mtl_reservations mr,

834:
835: UNION
836:
837: select asn_headers.expected_receipt_date exp_comp_date
838: from mtl_reservations mr,
839: rcv_shipment_lines ASN_LINES,
840: rcv_shipment_headers asn_headers
841: where mr.demand_source_type_id = 2
842: and mr.demand_source_line_id = l_config_line_id

Line 879: l_prim_uom_code mtl_reservations.primary_uom_code%type;

875: p_ato_line_id IN Number,
876: p_item_type_code IN varchar2) RETURN Number is
877: l_prim_rsv_qty Number;
878: l_rsv_qty Number;
879: l_prim_uom_code mtl_reservations.primary_uom_code%type;
880: l_line_id Number;
881:
882: Begin
883:

Line 902: from mtl_reservations

898: End if;
899:
900: select sum(primary_reservation_quantity),primary_uom_code
901: into l_prim_rsv_qty, l_prim_uom_code
902: from mtl_reservations
903: where demand_source_line_id = l_line_id
904: and supply_source_TYpe_id = 27
905: group by primary_uom_code;
906: