DBA Data[Home] [Help]

APPS.CTO_WIP_WORKFLOW_API_PK dependencies on MTL_RESERVATIONS

Line 335: from mtl_reservations

331:
332: v_counter := 0;
333:
334: select count(*) into v_counter
335: from mtl_reservations
336: --where demand_source_type_id = 2
337: where demand_source_type_id =
338: decode (l_source_document_type_id, 10, inv_reservation_global.g_source_type_internal_ord,
339: inv_reservation_global.g_source_type_oe ) -- bugfix 1799874

Line 632: from mtl_reservations

628: if upper(v_activity_status_code) = 'NOTIFIED' then
629:
630: v_counter := 0;
631: select count(*) into v_counter
632: from mtl_reservations
633: -- where demand_source_type_id = 2
634: where demand_source_type_id =
635: decode (l_source_document_type_id, 10, inv_reservation_global.g_source_type_internal_ord,
636: inv_reservation_global.g_source_type_oe ) -- bugfix 1799874