DBA Data[Home] [Help]

APPS.CTO_WIP_WORKFLOW_API_PK dependencies on MTL_RESERVATIONS

Line 325: from mtl_reservations

321:
322: v_counter := 0;
323:
324: select count(*) into v_counter
325: from mtl_reservations
326: --where demand_source_type_id = 2
327: where demand_source_type_id =
328: decode (l_source_document_type_id, 10, inv_reservation_global.g_source_type_internal_ord,
329: inv_reservation_global.g_source_type_oe ) -- bugfix 1799874

Line 612: from mtl_reservations

608: if upper(v_activity_status_code) = 'NOTIFIED' then
609:
610: v_counter := 0;
611: select count(*) into v_counter
612: from mtl_reservations
613: -- where demand_source_type_id = 2
614: where demand_source_type_id =
615: decode (l_source_document_type_id, 10, inv_reservation_global.g_source_type_internal_ord,
616: inv_reservation_global.g_source_type_oe ) -- bugfix 1799874